M
maca
Hi,
I have a graph fo representing rolling returns. It works very well fo
monthly and quarterly data, but when using weekly or daily data, i
gives me a "macro error".
I checked the data , and there is no missing value, the names ar
correct, the security settings are proper, and the whole calculation
are done in the same file, so no write error possible.
The code where it stops when debuging:
chRollRet.SeriesCollection(1).Values = Sheets("InputHelp").Range("M"
dt + 2 & ":M" & lr)
,where "chRollRet" is the Graph, "dt" is a integer variable giving th
first row, and "lr" is the integer giving the last row.
Can anyone help me, pls???
Cheers,
Maca
I have a graph fo representing rolling returns. It works very well fo
monthly and quarterly data, but when using weekly or daily data, i
gives me a "macro error".
I checked the data , and there is no missing value, the names ar
correct, the security settings are proper, and the whole calculation
are done in the same file, so no write error possible.
The code where it stops when debuging:
chRollRet.SeriesCollection(1).Values = Sheets("InputHelp").Range("M"
dt + 2 & ":M" & lr)
,where "chRollRet" is the Graph, "dt" is a integer variable giving th
first row, and "lr" is the integer giving the last row.
Can anyone help me, pls???
Cheers,
Maca