Rename a sheet

[greenfalcon]

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]

hmm now that im looking at this, how is it even possible that Sheets(1).Select returns an error? isnt it always there because it is a reference to the sheets in a workbook?

[greenfalcon]

I just found this from a vba developers site

"Index Number
A sheets Index number is determined by its position in the Workbook. The left most sheet will always have an Index number of 1, the next on the right will be 2 and so on. Excel VBA allows us to specify any Sheet by using it's Index number, but unfortunately this method is not used by Excel when we record a macro. It uses the Sheets Tab name like; Sheets("Budget").Select If this sheet was the third from the left we could use: Sheets(3).Select. This is often a better option than using the sheet tab name, but still has potential problems. By this I mean, the sheets position in the Workbook could change if we add, remove or move sheets."

how is it possible that Sheet(1) does not exist in my program?

[Tom Ogilvy]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Tom Ogilvy]

It isn't possible that it doesn't exist. It is possible that you can't
select it.

--
Regards,
Tom Ogilvy

"greenfalcon" <[email protected]>
wrote in message
news:[email protected]...
>
> I just found this from a vba developers site
>
> "Index Number
> A sheets Index number is determined by its position in the Workbook.
> The left most sheet will always have an Index number of 1, the next on
> the right will be 2 and so on. Excel VBA allows us to specify any Sheet
> by using it's Index number, but unfortunately this method is not used by
> Excel when we record a macro. It uses the Sheets Tab name like;
> Sheets("Budget").Select If this sheet was the third from the left we
> could use: Sheets(3).Select. This is often a better option than using
> the sheet tab name, but still has potential problems. By this I mean,
> the sheets position in the Workbook could change if we add, remove or
> move sheets."
>
> how is it possible that Sheet(1) does not exist in my program?
>
>
> --
> greenfalcon
> ------------------------------------------------------------------------
> greenfalcon's Profile:
http://www.excelforum.com/member.php...o&userid=13622
> View this thread: http://www.excelforum.com/showthread...hreadid=391859
>

[greenfalcon]

hehe, Shortly after i made my final post i checked a computer with the problem, you were correct in that the sheet in question was hidden. I had forgotten about that. Thanks for your help

Jason