Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Two Ranges
I'm writing code to update a command very similar to
ActiveChart.SetSourceData Source:=Sheets("Graph Data").Range("A1:A21,G1:M21"), PlotBy:=xlRows except I need to do it using the 'Cells()' format. For example, instead of using Range("A1:A21,G1:M21") since I'm using variables to reference the range, I believe I need to use the 'Cells()' format instead of the "A1:.." format. My attempts have looked something like: Range((Cells(1, 1), Cells(21, 1), (Cells(1, 7), Cells(10, 7)) This isn't working. Any help is greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Two Ranges
Union(Range(Cells(1, 1), Cells(21, 1)), Range(Cells(1, 7), Cells(10,7)))
-- Regards, Tom Ogilvy "SoCalExcel" wrote in message ... I'm writing code to update a command very similar to ActiveChart.SetSourceData Source:=Sheets("Graph Data").Range("A1:A21,G1:M21"), PlotBy:=xlRows except I need to do it using the 'Cells()' format. For example, instead of using Range("A1:A21,G1:M21") since I'm using variables to reference the range, I believe I need to use the 'Cells()' format instead of the "A1:.." format. My attempts have looked something like: Range((Cells(1, 1), Cells(21, 1), (Cells(1, 7), Cells(10, 7)) This isn't working. Any help is greatly appreciated. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still not working
I've updated the code to read:
ActiveChart.SetSourceData Source:=Sheets("Graph Data").Union(Range(Cells(1, 1), Cells(PriceBandCounter, 1)), Range(Cells(1, 7), Cells(PriceBandCounter, 7))), PlotBy:=xlRows This is returning a Run Time Error 438, Object doesn't support this property or method... -----Original Message----- Union(Range(Cells(1, 1), Cells(21, 1)), Range(Cells(1, 7), Cells(10,7))) -- Regards, Tom Ogilvy "SoCalExcel" wrote in message ... I'm writing code to update a command very similar to ActiveChart.SetSourceData Source:=Sheets("Graph Data").Range("A1:A21,G1:M21"), PlotBy:=xlRows except I need to do it using the 'Cells()' format. For example, instead of using Range("A1:A21,G1:M21") since I'm using variables to reference the range, I believe I need to use the 'Cells()' format instead of the "A1:.." format. My attempts have looked something like: Range((Cells(1, 1), Cells(21, 1), (Cells(1, 7), Cells (10, 7)) This isn't working. Any help is greatly appreciated. Thanks. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still not working
Dim rng as Range
PriceBandCounter = 20 with Worksheets("Graph Data") set rng = Union(.Range(.Cells(1, 1), .Cells(PriceBandCounter,1)), _ .Range(.Cells(1, 7), .Cells(PriceBandCounter, 7))) End With ActiveChart.SetSourceData Source:=rng, _ PlotBy:=xlRows -- Regards, Tom Ogilvy wrote in message ... I've updated the code to read: ActiveChart.SetSourceData Source:=Sheets("Graph Data").Union(Range(Cells(1, 1), Cells(PriceBandCounter, 1)), Range(Cells(1, 7), Cells(PriceBandCounter, 7))), PlotBy:=xlRows This is returning a Run Time Error 438, Object doesn't support this property or method... -----Original Message----- Union(Range(Cells(1, 1), Cells(21, 1)), Range(Cells(1, 7), Cells(10,7))) -- Regards, Tom Ogilvy "SoCalExcel" wrote in message ... I'm writing code to update a command very similar to ActiveChart.SetSourceData Source:=Sheets("Graph Data").Range("A1:A21,G1:M21"), PlotBy:=xlRows except I need to do it using the 'Cells()' format. For example, instead of using Range("A1:A21,G1:M21") since I'm using variables to reference the range, I believe I need to use the 'Cells()' format instead of the "A1:.." format. My attempts have looked something like: Range((Cells(1, 1), Cells(21, 1), (Cells(1, 7), Cells (10, 7)) This isn't working. Any help is greatly appreciated. Thanks. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks!
-----Original Message----- Dim rng as Range PriceBandCounter = 20 with Worksheets("Graph Data") set rng = Union(.Range(.Cells(1, 1), .Cells (PriceBandCounter,1)), _ .Range(.Cells(1, 7), .Cells(PriceBandCounter, 7))) End With ActiveChart.SetSourceData Source:=rng, _ PlotBy:=xlRows -- Regards, Tom Ogilvy wrote in message ... I've updated the code to read: ActiveChart.SetSourceData Source:=Sheets("Graph Data").Union(Range(Cells(1, 1), Cells(PriceBandCounter, 1)), Range(Cells(1, 7), Cells(PriceBandCounter, 7))), PlotBy:=xlRows This is returning a Run Time Error 438, Object doesn't support this property or method... -----Original Message----- Union(Range(Cells(1, 1), Cells(21, 1)), Range(Cells(1, 7), Cells(10,7))) -- Regards, Tom Ogilvy "SoCalExcel" wrote in message ... I'm writing code to update a command very similar to ActiveChart.SetSourceData Source:=Sheets("Graph Data").Range("A1:A21,G1:M21"), PlotBy:=xlRows except I need to do it using the 'Cells()' format. For example, instead of using Range("A1:A21,G1:M21") since I'm using variables to reference the range, I believe I need to use the 'Cells()' format instead of the "A1:.." format. My attempts have looked something like: Range((Cells(1, 1), Cells(21, 1), (Cells(1, 7), Cells (10, 7)) This isn't working. Any help is greatly appreciated. Thanks. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining pivot tables, then making a ranges. | Excel Discussion (Misc queries) | |||
Combining data ranges | Excel Worksheet Functions | |||
Most efficient formula/combining multiple data cell ranges/seperat | New Users to Excel | |||
Combining Ranges | Excel Worksheet Functions | |||
Combining specific ranges from multiple worksheets into one | Excel Worksheet Functions |