How to find the 1st sheet of a workbook

**sienahoops** · 07-15-2013, 05:41 PM

I have a macro that is designed to collect info from all sheets of a workbook, but i end up missing information if the workbook was last saved on a tab other than the 1st tab. How can i easily move back to cell A1 on the 1st tab of the workbook?

**MarvinP** · 07-15-2013, 06:05 PM

Hi sienahoops and welcome to the forum,

Excel has lots of objects and most of them have an INDEX number that can be used to work with them. Worksheets have names and also index numbers. The first one (on the left) can be found using Worksheets(1)..

Read http://msdn.microsoft.com/en-us/libr...ffice.11).aspx to see if it helps.

**sienahoops** · 07-16-2013, 05:01 PM

Originally Posted by MarvinP

Hi sienahoops and welcome to the forum,

Excel has lots of objects and most of them have an INDEX number that can be used to work with them. Worksheets have names and also index numbers. The first one (on the left) can be found using Worksheets(1)..

Read http://msdn.microsoft.com/en-us/libr...ffice.11).aspx to see if it helps.

Hi Marvin,
That did the trick. Many thanks.