Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range
In the following: ActiveChart.SetSourceData Source:=Sheets
("Sheet1").Range("E21:K21"), PlotBy _ :=xlRows instead of Range("E21:K21")above,I want to assign range based on currently selected cell as the begining of range and nest 6 cell in the same row. Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range
Hi Tony,
Try: Dim rng As Range Set rng = ActiveCell.Resize(1, 6) ActiveChart.SetSourceData Source:=rng, PlotBy:=xlRows --- Regards, Norman "Tony Reflinski" wrote in message ... In the following: ActiveChart.SetSourceData Source:=Sheets ("Sheet1").Range("E21:K21"), PlotBy _ :=xlRows instead of Range("E21:K21")above,I want to assign range based on currently selected cell as the begining of range and nest 6 cell in the same row. Please help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range
Hi Tony,
Re-reading, you want a seven cell range, so replace Set rng = ActiveCell.Resize(1, 6) with Set rng = ActiveCell.Resize(1, 7) --- Regards, Norman. "Norman Jones" wrote in message ... Hi Tony, Try: Dim rng As Range Set rng = ActiveCell.Resize(1, 6) ActiveChart.SetSourceData Source:=rng, PlotBy:=xlRows --- Regards, Norman "Tony Reflinski" wrote in message ... In the following: ActiveChart.SetSourceData Source:=Sheets ("Sheet1").Range("E21:K21"), PlotBy _ :=xlRows instead of Range("E21:K21")above,I want to assign range based on currently selected cell as the begining of range and nest 6 cell in the same row. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range | Excel Worksheet Functions | |||
Dynamic Range | Excel Worksheet Functions | |||
Dynamic Range | Charts and Charting in Excel | |||
Dynamic range | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |