I have the following code in VBA that works. I have a sheet that needed cells to be clear when file is Opened. The VBA in "Green" clears the needed cell in my "Contact Info" Sheet. I tried to add another sheet "elevate Pricing" to clear cells in that and eventually others sheets. The VBA in "Red" is what I tried...but it ends in error with VBA "Blue" (Endif). Its not working...any suggestions?
Steve
Please Login or Register to view this content.
Last edited by StevenRK72; 03-06-2024 at 04:03 PM.
Try 'activating' the sheet prior to taking any action.
Sheets("Elevate pricing").Activate
With Sheets ('elevate ....
I tried the following...but get a compile error at Endif "End if without block if"
Please Login or Register to view this content.
Please Login or Register to view this content.
Logit - Your code did the trick. I was able to clear req'd cells in 5 sheets! Thanks for your help!
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks