Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, Help me please
I can't make it work Worksheets("Sheet1").Range("A1").Consolidate _ Sources:=Array("'[File1.xls]Sheet2'!R1C1:R37C6", "'[File2.xls]Sheet3'!R1C1:R37C6"), _ Function:=xlSum I allays get message 'Can't open file '[File1.xls]Sheet2' Even if I write aSources = Worksheets("Sheet1").ConsolidationSources Worksheets("Sheet1").Range("A1").Consolidate _ Sources:=aSource, _ Function:=xlSum with workung source references I get the same message Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Consolidate | Excel Discussion (Misc queries) | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
GetObject method not work after Call Shell Method | Excel Programming | |||
Why QUIT method doesn't work after COPY method? | Excel Programming |