Automatically Select First Sheet 3

[mveera]

Hi,

ActiveSheet has properties to go to the next sheet or the previous sheet
ActiveSheet.Previous.Select
ActiveSheet.Next.Select

Like this, is there any property to go to the First sheet or the last sheet. We want something like a navigation tool.

Thanks
Veera

 

[DrBowes]

Sheets(1).Select
Sheets(Sheets.Count).Select

I think will select the first and last sheets.

 

[TonyJollans]

Hi mveera,

How about ...

Worksheets(1).Select

Enjoy,
Tony

 

[mveera]

Thank You Very much.

I was under the assumption that when we say Sheets(1).select it will select the sheet named sheet1.

Its working fine.
Veera

 

[DrBowes]

In order to do that you would enter:

Sheets("Sheet1&quot.Select

Sheets (or Worksheets) is a collection, you can get its members by number or name. It also has a Count property that I used to refer to the last sheet above.

Thanks for the star!