S
scantor145
Visual Basic 6.0 w/Excel
I would like to use Data|Consolidate to find both the average an
standard deviation for a group of cells for several sheets.
The example below shows the code for 3 sheets, but I have a macro tha
may generate N sheets. Is there a way to generalize the code below t
reflect the variations in the number of sheets to consolidate?
Code
I would like to use Data|Consolidate to find both the average an
standard deviation for a group of cells for several sheets.
The example below shows the code for 3 sheets, but I have a macro tha
may generate N sheets. Is there a way to generalize the code below t
reflect the variations in the number of sheets to consolidate?
Code