Dynamic Arrays and Formulae
 

Ok,

I'm about to pull out my hair because I can't figure out a way to d
this. I need to populate one cell with a formula that will reference
dynamic number of workbooks. These workbooks are opened by date, then
need to get the names of the workbooks and populate one cell with a SU
formula across all of the workbooks. So if there were 8 workbooks open
would need A1 in this worksheet of this workbook to SUM up B2 across al
other open workbooks! But as I said earlier there is no set number o
workbooks to open as they are opened by date range.

This code is as far as I have got:

sheets("Reports").Select
Range("B2").Select

For Each Workbook In Workbooks

Selection.FormulaArray = "='" & Workbook.Name & "'" & "!R2C2"
Next Workbook

And now I dont know, cos all this does is look at each workbook in tur
and change the formula each time, where I actually need it to keep o
adding up!
Help!

Thank

--
Josep

-----------------------------------------------------------------------
Joseph's Profile: http://www.excelforum.com/member.php...nfo&userid=563
View this thread: http://www.excelforum.com/showthread.php?threadid=31387