| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Mutiple WorkSheets
Thanks,
This will help me also. Ben -----Original Message----- A basic approach would be: Dim sh as Worksheet Dim rng as Range Dim sTarget as String sTarget = "SearchString" for each sh in thisworkbook.worksheets set rng = nothing set rng = sh.cells.find(sTarget) if not rng is nothing then sh.Activate rng.select msgbox "target found, click to continue search" end if Next I can't guess how you want to interact with the user, so this just demonstrates looping through the sheets and using find. Regards, Tom Ogilvy "Ben Jimenez" wrote in message ... Hello, I'm trying to create a search prompt that will search all worksheets in an open Excel file. I'm creating it as a macro. Any ideas how to search each sheet for the same data and i give some kind of info that tells the user witch sheet the info they are looking for is on?????? Ben . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup on mutiple worksheets | Excel Discussion (Misc queries) | |||
| can i.. do a COUNT through mutiple worksheets? | Excel Discussion (Misc queries) | |||
| creating mutiple worksheets | Excel Discussion (Misc queries) | |||
| printing mutiple worksheets on one page | New Users to Excel | |||
| Combine Mutiple Worksheets into one | Excel Discussion (Misc queries) | |||
Threaded Mode
