All right, then first you should create a variable that would contain
the name of your sheet :
dim sheet_name as string
sheet_name="Sheet" & a
' you can view if it is correct :
msgbox sheet_name
' then you can reference a worksheet :
worksheets(sheet_name)
--
sarasta
------------------------------------------------------------------------
sarasta's Profile:
http://www.excelforum.com/member.php...o&userid=10956
View this thread:
http://www.excelforum.com/showthread...hreadid=267156