Find Next Methond???
Hi,
I'm having troubles using the FindNext Method. I'm searching a Column
of Data for a number, when I find it I want the row number and then I
want to keep searching the document till i find other instances of the
number.
So the psuedo code would look like this:
S_Row(1) = ActiveSheet.Columns("B").Find(1500).Row
S_Row(2) = FindNext Method here
' So it searchs the entire column for every instance of 1500, I then
want to take those and match them to corresponding dates, which I can
do, its just the FindNext I have a problem with.
Thanks
Dwight
|