View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default How can I use a variable to refer to multiple worksheets?

You have the Worksheets collection
e.g Worksheets(2)

NickHK

"dc_area_mcse" ...
I need to refer to the same cells in multiple worksheets. How can I do
this,
i.e. WorksheetX, where X is used in a loop increasing until all the sheets
are processed?