Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving on to the next tab in a macro
Hello!
Is there any way to write into a macro that it should search through several sheets in a workbook? For eg, loop it to do a search in tab one and then move on to search tab 2 when its finished? Thanks for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving on to the next tab in a macro
A looping macro for each sheet to search and end the macro when found.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Wombat" wrote in message ... Hello! Is there any way to write into a macro that it should search through several sheets in a workbook? For eg, loop it to do a search in tab one and then move on to search tab 2 when its finished? Thanks for any help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving on to the next tab in a macro
code something like this will do it...
dim wks as worksheet for each wks in worksheets msgbox wks.name next wks Note that we are referencing wks and not the active sheet as the above code does not activate the sheets. If you are intending to use this with a recorded amcro then add wks.select to your code. -- HTH... Jim Thomlinson "Wombat" wrote: Hello! Is there any way to write into a macro that it should search through several sheets in a workbook? For eg, loop it to do a search in tab one and then move on to search tab 2 when its finished? Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving the second row with a macro | Excel Worksheet Functions | |||
Moving macro from one PC to another | Excel Discussion (Misc queries) | |||
moving macro | Excel Worksheet Functions | |||
Moving a macro to other PCs | Excel Discussion (Misc queries) | |||
Moving right in a macro | Excel Discussion (Misc queries) |