Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming |