How to locate the first sheet in a workbook?

**Wino** · 07-29-2009, 10:36 AM

I'd like to find the first sheet in my workbook.

I know how to find the last sheet:

Please Login or Register  to view this content.

I would like to find the first sheet in a similar manner.

Anybody?

**DonkeyOte** · 07-29-2009, 10:39 AM

The first sheet can be located by it's index position of: 1, eg:

Please Login or Register  to view this content.

**Wino** · 07-29-2009, 10:45 AM

Well, that's easy! thx!

Another question regarding this:

How can I move sheet(1) to the last position?

**DonkeyOte** · 07-29-2009, 10:46 AM

One way:

Please Login or Register  to view this content.

**Wino** · 07-29-2009, 11:05 AM

that worked great!
could have deducted that myself...

thx

Re: How to locate the first sheet in a workbook?