Any ideas why I am getting this message when I have clearly defined a range and the sheet is unprotected
Any ideas why I am getting this message when I have clearly defined a range and the sheet is unprotected
Last edited by tigerdel; 06-02-2013 at 11:55 AM.
An error on you code maybe?
What is your code?
Regards, TMS
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
Are you selecting the range via code, or via sheet interaction (mouse + CtrlClick)? If the former, is the range non-contiguous?
Assume range is A1, B1, D1, F1
One would think the following is correct:when in fact the range should be passed as one argument using commas like this:Please Login or Register to view this content.
Just a thought.Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thanks Guys - sorted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks