Can someone please tell me what is wrong with this syntax? I recorded the macro, then tried to build it in a vba script so I could use variables and arrays, etc to go thru lots of workbooks.

This is to put quotes around the worsheet name...
RollUpToWs = DoubleQuote & RollUpToWs & DoubleQuote

Worksheets(RollUpToWs).Range("TargetImpact").Conso lidate Sources:=MyArrayString

Here is MyArrayString:
Array('C:\Documents and Settings\Administrator\My Documents\Cost Tracking\Rollups\[TestWB.xls]Sheet1'!R21C8:R24C10,'C:\Documents and Settings\Administrator\My Documents\Cost Tracking\Rollups\[TestWB.xls]Sheet2'!R21C8:R24C10),Function:=xlSum TopRow:=False, LeftColumn:=False, CreateLinks:=False

Any help is greatly appreciated!
Regards,
glr

Hi Grouth

The problem might be in the array string

Change the string to

MyArrayString =
Array('C:\Documents and Settings\Administrator\My Documents\Cost Tracking\Rollups\[TestWB.xls]Sheet1'!R21C8:R24C10,'C:\Documents and Settings\Administrator\My Documents\Cost Tracking\Rollups\[TestWB.xls]Sheet2'!R21C8:R24C10) and [b]assign it to source[/b[

and separate the rest to another string

Function:=xlSum TopRow:=False, LeftColumn:=False, CreateLinks:=False


http://www.vbadud.blogspot.com

It still encounters the '1004' error at this line:
Selection.Consolidate Sources:=Source & ",Function:=xlSum TopRow:=False, LeftColumn:=False, CreateLinks:=False"

The value of Source (from the immediate window) is:
Array('C:\Documents and Settings\grouth\My Documents\Cost Tracking DEV\Rollups\[TestWB.xls]Sheet1'!R21C8:R24C10,'C:\Documents and Settings\grouth\My Documents\Cost Tracking DEV\Rollups\[TestWB.xls]Sheet2'!R21C8:R24C10)

Any other suggestions are most appreciated.
Gary

Thanks for the help. As it turns out, I was trying to write the contents of the string that goes between the parenthesis, e.g. Array(). I was trying to put in the quotes, commas, etc. All I really needed to do was to loop through the array, putting the path and range, and let VBA put the punctuation in for me.

Shasur, thanks again for your assistance!

Regards,

Gary