group sheets with macro in excel

Giganews Newsgroups
Subject: group sheets with macro in excel
Posted by:  jannkatt
Date: Thu, 18 May 2006

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.

Replies