Range.Find examples

[Howard31]

Hi All,

Can anyone suggest a place where I can find examples for Range.Find?

 

[JLGWhiz]

There is a very good one in the VBA help file. Just open the VBE (Alt + F11)
and click on the help icon, type in Find or FindNext and select the one you
want from the list of options that appear in the help topic window.

 

[JLGWhiz]

If you are using the web based news reader, you can use the search box over
the posting window to seach for previous postings by typing in the topic and
clicking GO.

 

[Dave Peterson]

You could always record a few different macros when you try different things in
the Find dialog.

 

[Howard31]

Hi Dave,

I very much appreciate your help, I will try recording those macros as you
described.

Many Thanks

 

[Dick Kusleika]

Hi All,

Can anyone suggest a place where I can find examples for Range.Find?

http://www.dailydoseofexcel.com/archives/2004/03/29/the-find-method/

 

[Howard31]

Hi Dick,

I read your article about the Find method, and found it quite helpful,
especially the part that the default arguments of the Find method changes
according to what was specified in the last use of Find.

Many thanks!