Getting the index number by supplying worksheet name

[ajitpalsingh200]

Hie

lets say the worksheet name is "sheet1", how do i get the index numbe
of that particular worksheet?

thankx in advanc

 

[JE McGimpsey]

One way:

Dim nIndex As Long
nIndex = Worksheets("sheet1").Index