| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using variables in the range of source data
I have the following line in working code: ActiveChart.SetSourceData Source:=Sheets("Traffic model").Range("M14:M32"), PlotBy:=xlColumns and I want to change the argument of .Range() to use variables instead. So I wrote: ActiveChart.SetSourceData Source:=Sheets("Traffic model").Range(Cells(initial_blank_count - 1, initial_column + 7), Cells(Rows, initial_column + 7)), PlotBy:=xlColumns The error a runtime error to effect of an application- or object-defined error. The variables were used earlier in the sub without problems. How do I straighten this out please? TIA ... Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation to range names for Chart Source Data | Charts and Charting in Excel | |||
| Prob with ChartSource DataData Range | Charts and Charting in Excel | |||
| How do I select on two variables in a range of data in excel | Excel Worksheet Functions | |||
| Chart source data range | Excel Programming | |||
| How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) | |||
Threaded Mode
