LinkBack URL
About LinkBacks
I need to alter the following macro to skip these sheets
"Status", "Compile", "Cer-Burdens"
Can you help?
HTML Code:
I need to alter the following macro to skip these sheets
"Status", "Compile", "Cer-Burdens"
Can you help?
HTML Code:
Last edited by caliskier; 10-04-2015 at 04:32 PM.
Please Login or Register to view this content.
Ben Van Johnson
If you simply want to skip certain sheets, then see the following snippet of code.
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Thanks but I get "Object does not support this property or method error"Originally Posted by protonLeah
Please Login or Register to view this content.
I loaded yours this way...If you simply want to skip certain sheets, then see the following snippet of code.
Please Login or Register to view this content.
I get this error....HTML Code:
"Object variable or with block variable not set", did i put it in the wrong place?
It needs to be inside the for loop because until then vWShts hasn't been set to any worksheets and also that line of code will only run once if it's before the loop.
Please when you get an error don't just say you got an error. You got an error on a certain line and it's important to share which line of code caused the error. I'm pretty sure I know which one this time, but to help us better help you in the future, please keep that in mind.
Please Login or Register to view this content.
I just realized you changed the x I gave you in my code to S. When you do that you have to change all the x's to S's!
Thank you, and I apologize about the code location, I will be more specific next time... Thanks again for your help, much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks