sheet number

[lezawang]

Hi
in VBA, if I say worksheets(1), which sheet is that? the first one in the left hand side (physically the first one) or the first sheet that is created?
lets say I have 4 sheets A,B,C and D. A was the first sheet created. Then I changed the order, copy/move etc and now I have these sheets listed as

D, A, F, B, C

Which one is worksheets(1) now?

Can I print/display sheets number? Thank you

 

[dreid1011]

Testing indicates that Worksheets(1) will return the name of the sheet farthest left, in this case "D".

And yes, you can:

Sub SheetsName()
MsgBox Worksheets(1).Name
End Sub