Hi, This macro does almost exactly what I need to do but it only works on sheet 1 and a single range (a8 to b20) .
Can you help me to adjust it so it will work for multiple sheets ( sheet 2,3, etc) and multiple ranges on a single sheet.
The ranges will be different for each sheet.
Thank you very much.
Please Login or Register to view this content.
Please Login or Register to view this content.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
natefarm,
You are a genius and a nice person. thanks for your generous assistance.
Nate farm,
You are still a genius and a nice person but I got an error message.
Error #91- Object variable or with block variable not set. I have no idea what that means . can you look at where it stopped and tell me what to do next ? i would appreciate it.
It stopped at ws.unprotect "9273" . "9273" is the password
Please Login or Register to view this content.
I ran into the same thing initially. You need to move the variable definitions for ws and rng back outside of the subroutines like I had them so the scope encompases both subroutines. The way you have it, the ws in ResetColorIndex is a different variable from the one in Protect, so it doesn't know what sheet you're talking about.
WORKS LIKE A CHAMP !! Thanks a million.
No genius, but thanks anyway! Glad it worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks