I do not disagree.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Wednesday, February 22, 2012 7:36 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help with code please.
Hey Don,
I wasn't saying my modification would be faster. Find s
A1.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Tuesday, February 21, 2012 1:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Asa, Agree about the "undue attention". My ex
t: Tuesday, February 21, 2012 7:14 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Don, your code works fine for the selection. I would gladly accept any
correction if somebody did that to me. My only point is that
1. Find doesn't stop the loop
in other
>
> > On Wed, Feb 22, 2012 at 3:03 AM, dguillett1 wrote:
>
> >> Asa, Agree about the “undue attention”. My experience tells me that
> >> just leaving it out ( as I did) serves the purpose. Maybe you can time
> >> it.??
>
> >&g
Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sam Mathai Chacko
> *Sent:* Tuesday, February 21, 2012 6:56 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help with code please.
>
> Haha, I like the way you put that Don. I agree 6 of
sAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Tuesday, February 21, 2012 6:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Haha, I like the way you put that Don. I agree 6 of 1 is half a dozen of
another. On the other point however
uille...@gmail.com
>
> *From:* Asa Rossoff
> *Sent:* Tuesday, February 21, 2012 2:10 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Help with code please.
>
>
> Too true Don//
>
>
>
> .Find finds the first match… and stops.
>
Subject: RE: $$Excel-Macros$$ Help with code please.
Too true Don//
.Find finds the first match… and stops.
However, with all the undue attention to this code, I will offer a suggested
update. The Set mg = .Cells.Find lines can be changed to the following to
prevent an oft-overlooked issue
[mailto:a...@lovetour.info]
Sent: Tuesday, February 21, 2012 12:11 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Help with code please.
Too true Don//
.Find finds the first match. and stops.
However, with all the undue attention to this code, I will offer a sugges
ooglegroups.com]
On Behalf Of dguillett1
Sent: Tuesday, February 21, 2012 11:42 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Sam, The code I provided does stop the macro with the selection. Yes, goto
could be used but OP said
select sheet
select cell
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
You'd want to exit the routine if the cell is found. Also, you can use
application.goto to select the cell. I would also be weary about hidden sheets
if any.
Sub lookinallsheets()
Dim wks As Work
Original Message- From: Bob
> Sent: Monday, February 20, 2012 2:28 PM
>
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Help with code please.
>
>
> There will never be more than 1 of the same number. I just need it to
> select the sheet that it's o
hDirection:=xlNext)
If Not mf Is Nothing Then
.Select
mf.Select
End If
End With
Next ws
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Bob
Sent: Monday, February 20, 2012 2:28 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Help with c
e info??
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Bob
> Sent: Sunday, February 19, 2012 6:33 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Help with code please.
>
> I almost have the
work with the found item. More info??
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Bob
Sent: Sunday, February 19, 2012 6:33 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Help with code please.
I almost have the code the way I need it. BUT I wa
I almost have the code the way I need it. BUT I want it to Find
everything within in the same Workbook, not just on the Index
Worksheet. Thanks in advance!!!
Private Sub CommandButton1_Click()
Dim IndividualSearch As String
IndividualSearch = InputBox("What's the part number you're looking
for?",
16 matches
Mail list logo