Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding every instance of a value in a multi-sheet workbook
I need to find every occurrence of a unique ID in a multi-sheet
workbook. I have already implemented this in code simply by looping over the sheets, finding the column (it can potentially move from sheet to sheet, but doesn't yet), and then looping over that column to find the row numbers and put them in an array. But now I'm thinking that this might not be the best way to do this, and some sort of Find would be more efficient. I've never seen anything like this though, a variation of Find that returns a single "something" with all of the hits in it. Any ideas? Maury |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with multi sheet workbook | Excel Worksheet Functions | |||
set a permentant print area in a multi-sheet workbook | Excel Worksheet Functions | |||
Finding the top two in a multi page workbook | Excel Programming | |||
Convert Multi-Sheet Workbook to Standalone Executable | Excel Discussion (Misc queries) |