Trying to limit .Find to a specific range
If that is all you changed, you are wasting a lot of time in your code. You
are also changing your loop variable within the loop which is not
recommended, but you don't need the loop anyway.
--
Regards,
Tom Ogilvy
wrote in message
...
Thanks, that worked perfectly
On Sun, 2 Nov 2003 15:42:14 -0600, "Chip Pearson"
wrote:
Bill,
Just change
With Cells
to
With Range("A1:A10")
or whatever range you want to search.
|