View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jannkatt
 
Posts: n/a
Default group sheets with macro in excel

Is there a way to easily group worksheets in excel using a macro so that some
function can be performed on all sheets at the same time? I have over 100
sheets and currently have to list each sheet in the macro. This is time
consuming since the sheet names change every year.

Thanks.