Find, Findnext VBA Loop

[SMS - John Howard]

I am using a Find, FindNext loop in a vba macro in Excel XP professional on
a Windows 2000 platform.

The procedure works fine with the exception of finding the SECOND instance
of the criteria and not the first when the criteria is met in the first row
of the search range.

I presume this is the default.

The only methods I am adding are Lookin xlValues and Lookat xlWhole.

How can I enforce finding the first instance.

I have, for now used a workaround of redfining the search range with an
additional top row.
This is however hardly very elegant nor usable in all instances.

Can anyone assist


Regards

John Howard
Sydney, Australia

 

[Guest]

Hi
you may post your existing code (the find/findnext loop)

 

[Alan Beban]

I am using a Find, FindNext loop in a vba macro in Excel XP professional on
a Windows 2000 platform.

The procedure works fine with the exception of finding the SECOND instance
of the criteria and not the first when the criteria is met in the first row
of the search range.

I presume this is the default.

The only methods I am adding are Lookin xlValues and Lookat xlWhole.

How can I enforce finding the first instance.

I have, for now used a workaround of redfining the search range with an
additional top row.
This is however hardly very elegant nor usable in all instances.

Can anyone assist


Regards

John Howard
Sydney, Australia

Add a second parameter After:=[the last cell in the range]

Alan Beban

 

[Otto Moehrbach]

John
To add to what Alan gave you. If your range is a variable, say,
MyRange, then use:
After:=MyRange(MyRange.Count)
HTH Otto

 

[SMS - John Howard]

Alan and Otto,

Many thanks.
Your solutions worked perfectly

Regards

John Howard
Sydney, Australia

 

[Alan Beban]

Alan and Otto,

Many thanks.
Your solutions worked perfectly

Regards

John Howard
Sydney, Australia

You're welcome. Thanks for the feedback.

Alan Beban