sarasta Wrote:
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. :)

You don't understand the problem.
1. worksheets(a) can be used only the sheets are in order, so I can'
use it
2. a=2; worksheets("Sheet" & a) doesn't work

How can I use "a" as a parameter

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