how to access a sheet by only knowing its position

[s95a1li]

To access a cell A1 in the "Sheet2" sheet I simply use =Sheet2!A1

How can I access the second sheet in the workbook without referring to its name? (It will be different from time to time)

In visual basic I can access the 2nd sheet in a workbook with
Sheets(2).Cell(1,1).Value

Is there a way to access a sheet the same way by just using excel.

Something like =[Sheet which has the second position in the workbook]!A1

Thanks a lot in advance!

Andy

 

[Juan Pablo González]

Thanks for that tip and link, JPG. I just read that thread and I gotta say, some of the formulas y'all cook up (especially Mr. Akyurek) are downright scary sometimes.

And Jon, thank ya kindly for the compliment, but after seein' JPG's handiwork on that other thread, my hat-size ain't a goin' up too much.

Yes, I agree !! but just gotta love a well "cooked" formula !!

 

[s95a1li]

Thanks for the quick response and great advice!

/Andy