Hi,
in my code I need to look at a worksheet's column A and find the occurance of a particular string.
Column A IS sorted so the string will be togther.
for example,
I'm looking for "hdw"
this occurs in rows 50-60
it is followed by a range of another string, so I need to find all rows that contain hdw.
I wish to set a two variables. 1 to the row number of the first instance of hdw (e.g. 50)
and the second for the last row (e.g. 60)
can anybody advise please?
thanks in advance,
Matt
Bookmarks