Select First Sheet in Workbook

[EdWoods]

Hi,

I want to have a simple macro that will select the first Worksheet, no matter what it's called.

The simple command

Please Login or Register  to view this content.

won't work if the name of the first sheet has been renamed to something other than Sheet1.

Thanks.

Paul.

[Jarko28]

hi,

try:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[EdWoods]

Awesome. Thanks for that.

Now, how about selecting the last sheet (no matter how many there are, or what they're called?

Thanks.

[jolivanes]

Please Login or Register  to view this content.

[EdWoods]

Awesome! Any one last one (I promise). How do I count how many sheets there are?

Cheers.

[MarvinP]

Sheets.Count

[EdWoods]

Ah, great. I was using Sheet.Count (without the "s") and wondering why it wouldn't work!

Excel Forum to the rescue again! Thanks.