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
-------------------
Selection.Consolidate Sources:=Array("[Book1]Sheet1!R1C1", _
"[Book1]Sheet2!R1C1", "[Book1]Sheet3!R1C1"), Function:=xlAverage, TopRow:= _
False, LeftColumn:=False, CreateLinks:=Fals
-------------------

--
scantor14
-----------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...fo&userid=1476
View this thread: http://www.excelforum.com/showthread.php?threadid=26390