ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find Macro across workbook (https://www.excelbanter.com/excel-programming/349476-find-macro-across-workbook.html)

[email protected]

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



All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com