View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sarasta[_6_] sarasta[_6_] is offline
external usenet poster
 
Posts: 1
Default Access worksheet by name


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