1 is an idex number indicating the first sheet in the tab order if all
sheets are visible. Possibly, you have made the first sheet hidden, so it
can't be selected.

--
Regards,
Tom Ogilvy

"greenfalcon"
wrote in message
...

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 does
not exist. Is there a way to rename one of my other sheets, say Sheet2
to be Sheets(1)

Any help is great.

Green


--
greenfalcon
------------------------------------------------------------------------
greenfalcon's Profile:
http://www.excelforum.com/member.php...o&userid=13622
View this thread: http://www.excelforum.com/showthread...hreadid=391859