Hi,
I'm trying to automate a chart plot, but I'm stuck on how to define a dynamic range.
ActiveChart.SetSourceData Source:=Sheets("ByFabLot%").Range("A4:A58, D4:D58"), _
PlotBy:=xlColumns
Instead of a static range, the A58 and D58 will be a variable and will be expanded.
I was trying to put in "A4: Xrow, D4: Yrow" as my variable, but i get an errow. Any suggestion? Thanks in advance
I'm trying to automate a chart plot, but I'm stuck on how to define a dynamic range.
ActiveChart.SetSourceData Source:=Sheets("ByFabLot%").Range("A4:A58, D4:D58"), _
PlotBy:=xlColumns
Instead of a static range, the A58 and D58 will be a variable and will be expanded.
I was trying to put in "A4: Xrow, D4: Yrow" as my variable, but i get an errow. Any suggestion? Thanks in advance