Getting the index number by supplying worksheet name
 

Hie

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

thankx in advanc

--
ajitpalsingh20
-----------------------------------------------------------------------
ajitpalsingh200's Profile: http://www.excelforum.com/member.php...fo&userid=1615
View this thread: http://www.excelforum.com/showthread.php?threadid=31998

Getting the index number by supplying worksheet name
 

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?