One way:

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


In article ,
ajitpalsingh200 wrote:

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