I have been using this macro for years but recently it stopped working. The VBA section that selects an array of sheets doesn't seem to work anymore. I could split them out and do each sheet one at a time but that seems inefficient.
Please Login or Register to view this content.
Maybe explain in a concise manner what you want to achieve.
Experience trumps academics every day of the week and twice on Sunday.
After further review, the macro failed. due to some of the sheets being hidden. Do I add a step to unhide all sheets or is there a way to ignore hidden sheets.
I have 24 sheets that monthly they need to see the monthly change between the Variance in Columns T & AM. We accomplish this by copying the data in Column T & AM and paste as values in Column U & AN as values,
If a sheet is hidden, you can't select it, nor can you select anything on it. So, don't use Select.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks