View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_4_] Alan Beban[_4_] is offline
external usenet poster
 
Posts: 171
Default VBA searching a row

Don Guillet's solution will find a cell containing an s; Tom Ogilvy's
will find a cell containing only an s.

Alan Beban

Fargo Holiday wrote:
Howdy,
I want to search a row, say from B2 to O2, for a cell containing an s and
get the position of that cell, preferably in a format of number of cells
from the left. I've looked into using .Find, but I haven't been able to
figure out a way to get the information that I want. Could any of you point
me to an example involving this scenario, or give me some pointers?

Thanks a bunch,
Fargo