Home |
Search |
Today's Posts |
#1
|
|||
|
|||
new at this - please help!
This is what the macro produced: ActiveChart.SeriesCollection(1).Values = "='Daily Input'!R6C9:R17C9" This is what I tried to do - but it gives an error. I need to substitute the values in the Cells reference with vairables for the module work correctly. ActiveChart.SeriesCollection(1).Values = Worksheets("Daily Input").Range(Cells(6, 9), Cells(17, 9)) Please tell me what I am doing wrong. |