Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column index number | Excel Discussion (Misc queries) | |||
Column index number | Excel Discussion (Misc queries) | |||
lookup row index number | Excel Discussion (Misc queries) | |||
Retrieve Row index number | Excel Discussion (Misc queries) | |||
having one more than one column index number | Excel Worksheet Functions |