Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Macro across workbook
My find macro can find data across the entire workbook--across many
sheets, but when it finds the data, it doesn't *go* there. If I am looking at one sheet and hit my macro, and the data is on another sheet, it finds it on the other sheet, but it doesn't switch my view to that next sheet. How do I do this? my macro as it is now: Sub seech() ' ' seech Macro ' Macro recorded 1/3/2006 by L Cloutier ' ' Keyboard Shortcut: Option+Cmd+q ' Cells.FindNext(After:=ActiveCell).Activate ActiveCell.Activate End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find all formulas in a workbook | Excel Discussion (Misc queries) | |||
find and replace within workbook macro | Excel Discussion (Misc queries) | |||
Find Macro across workbook | Excel Worksheet Functions | |||
How to Find Workbook with Macro | Excel Discussion (Misc queries) |