I have following code with static range. The letter "D" in the range must be a letter of last right column.
ActiveChart.ChartType = xl3DColumnStacked100
ActiveChart.PlotBy = xlRows
How can I change this code to dynamic range. I tryed using XlToRight, but I have confused with that. Any idea?