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
|