Hi all,
I was wondering if anyone knows some code that I can add to a macro that will repeat that macro on every subsequent worksheet in the workbook.
Thanks
Hi all,
I was wondering if anyone knows some code that I can add to a macro that will repeat that macro on every subsequent worksheet in the workbook.
Thanks
Last edited by RPOD; 08-30-2009 at 02:19 AM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks for the quick reply.
Is there a way to have the macro stop at the last worksheet in the workbook?
It appears that now the macro runs on preceding sheets in the workbook as well.
Thanks..
If you want the macro to run on the Activesheet and every sheet AFTER that one and not on any of the sheets that come prior to the activesheet, maybe this would do:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks JB -
Works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks