I've got a table of data in a worksheet called "Charts"... the table starts in cell "B2" and the rest changes (dynamic chart).
My problem is "Z" needs to be dynamic, as the number of rows will constantly change. What's the best way to tackle this?
thanks.
Code:
ActiveChart.SetSourceData Source:=Sheets("Charts").Range("B2" & ":" & "Z" & numColumns), PlotBy _
:=xlColumns
My problem is "Z" needs to be dynamic, as the number of rows will constantly change. What's the best way to tackle this?
thanks.