There are a number of ways to loop through the sheets in the workbook. Here are three examples.
In the first example, I create an Object variable and use the For Each construct. As you know, Sheets can be Worksheets, Chart Sheets and Dialog Sheets. They can also be Macro sheets, but those [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/03/12/looping-through-sheets/
Posted
Mar 12 2009, 05:33 PM
by
Daily Dose of Excel