Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any ideas?
Any ideas why this won't work??
Sub Consolidate() Set Consrng = Sheets(Array("LMU", "Kit", "SMLC", "WLG", "SMLC Cab", "Serv Cab", "Ntwk Kit", "TDAX", "EMS", "SCOUT", "Dir Coup")) & "!R5C1:R500C133" Forecast.Range("B5").Consolidate Sources:=Array(Consrng), _ Function:=xlSum, TopRow:=True, LeftColumn:=True, CreateLinks:=False End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any ideas?
What was the error message?
Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Steph" wrote in message om... Any ideas why this won't work?? Sub Consolidate() Set Consrng = Sheets(Array("LMU", "Kit", "SMLC", "WLG", "SMLC Cab", "Serv Cab", "Ntwk Kit", "TDAX", "EMS", "SCOUT", "Dir Coup")) & "!R5C1:R500C133" Forecast.Range("B5").Consolidate Sources:=Array(Consrng), _ Function:=xlSum, TopRow:=True, LeftColumn:=True, CreateLinks:=False End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any ideas if this can be done | Excel Worksheet Functions | |||
Anyone else have any ideas?? | Excel Discussion (Misc queries) | |||
Any Ideas? | Excel Worksheet Functions | |||
Any Ideas | Excel Discussion (Misc queries) | |||
Programming Ideas | Excel Programming |