View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Referencing Worksheets

I have multiple worksheets, in my workbook, each renamed from original
"Sheet#" name. Is there a way to still reference each sheet in a macro as
Sheet1, Sheet2...., or can you only reference them by their current
caption-name?

Thanks,
Les