PDA

View Full Version : Syntax error



JZB
08-24-2009, 04:19 AM
Hi guys

I am creating a chart macro with variables around the series data.

There are two pieces of data, 2008 and 2009. the only variable that needs defining is the row number on each.

I have succesffully defined these (mydata and mydata 2)

The issue comes when inputting the variables into the syntax.

Series one is fine but series two syntax is a problem

ActiveChart.SeriesCollection(2).Values = "='[2008 PnL.xls]Income'!Rmydata2C4:Rmydata2C15"

The above variable incorporation is pretty schoolboy i know. :dunno

Any ideas would be appreciated

Thanks

Jon

JZB
08-24-2009, 06:26 AM
this is solved

ActiveChart.SeriesCollection(2).Values = "='[2008 PnL.xls]Income'!R" & MYDATA2 & "C4: R" & MYDATA2 & "C10"

cheers