Thread: using variables in the range of source data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
gvm gvm is offline
external usenet poster
  
Posts: 38
Default using variables in the range of source data
Thanks, I tried the following but got same error:
ActiveChart.SetSourceData Source:=Sheets("Traffic
model").Range(Sheets("Traffic model").Cells(initial_blank_count - 1,
initial_column + 7), Sheets("Traffic model").Cells(Rows, initial_column +
7)), PlotBy:=xlColumns
Reply With QuoteReply With Quote