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. |
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 |