I have a workbook with many worksheets which are not in order. So I
can't use worksheets(a).

Ex: If a=2 then I want to use Sheet2, not the second sheet.


--
stefantem
------------------------------------------------------------------------
stefantem's Profile: http://www.excelforum.com/member.php...o&userid=13594
View this thread: http://www.excelforum.com/showthread...hreadid=267156

So, what is your problem ? You have 2 ways to reference a sheet :
1. using indexing in a worksheets object collection : worksheets(a)
where a is an integer.
2. using naming worksheets("sheet_name")

There's nothing you can do more. :

--
sarast
-----------------------------------------------------------------------
sarasta's Profile: http://www.excelforum.com/member.php...fo&userid=1095
View this thread: http://www.excelforum.com/showthread.php?threadid=26715