View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dewey Dewey is offline
external usenet poster
 
Posts: 16
Default 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