Thread: Next function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Next function?

Look in Excel VBA helps for the FindNext command. Look at the code example.
This will show you how to find multiple instances of a search term.

--
Regards,
Tom Ogilvy

"John Keturi" wrote in message
news:q7Gbd.28479$hj.25638@fed1read07...
I have a cell which uses the "VLOOKUP" function. Is there a way I could
assign a macro to a cmd button, which would search for the next occurance

of
the "lookup value", and then refresh or display it in the same or a
different cell?