Subscript error after renaming worksheet
Posted by Becket on February 01, 2002 11:01 AM
No matter how I try to get around this, whenever I rename my worksheet, then run my macro I get a "subscript out of range." If I change the name back to sheet4, I have no problems whatsoever.
I've tried cutting the macro out, saving the program and then putting the macro back in. I've tried copying the worksheet. I've tried copying the file.
I can't just open a new book and rewrite the macro, it's mega-pages long. Any ideas?