I have a workbook that references different sheets with the command
Sheets(1).Select
Problem is this sheet somehow no longer exists in my workbook.
When i get to this line in my code it errors out because the sheet doe
not exist. Is there a way to rename one of my other sheets, say Sheet
to be Sheets(1)
Any help is great.
Gree
--
greenfalco
-----------------------------------------------------------------------
greenfalcon's Profile:
http://www.excelforum.com/member.php...fo&userid=1362
View this thread:
http://www.excelforum.com/showthread.php?threadid=39185