Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Arrays | Excel Discussion (Misc queries) | |||
Dynamic Range and arrays | Excel Worksheet Functions | |||
Dynamic arrays | New Users to Excel | |||
Dynamic Arrays | Excel Worksheet Functions | |||
dynamic arrays in excel | Excel Programming |