View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.