Find, Findnext VBA Loop
Hi
you may post your existing code (the find/findnext loop)
"SMS - John Howard" wrote:
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
|