![]() |
ActiveChart, Data!R code
I am troubleshooting some prior code which is giving me a 'invalid parameter'
error 1004. c and d are global integers. This was created in xl2003 and appears not to work in xl2007. Are there suggestions on how to rewrite this? ActiveChart.SeriesCollection(a).Name = "=Data!R" & c & "C" & d ActiveChart.SeriesCollection(a).XValues = "=Data!R" & c & "C" & d + 1 ActiveChart.SeriesCollection(a).Values = "=Data!R" & c & "C" & d + 2 ActiveChart.SeriesCollection(a).BubbleSizes = "=Data!R" & c & "C" & d + 3 |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com