Hi im trying to create code to create a chart form some data in exceli recorded a macro to get the code which all works fine but the macro puts in absolute cell addressesi.eactivechart.setsourcedata source:=sheets("Sheet1".range("A1:M5", plotby:=xlcolumnshow do i replace "A1:M5" so that the entire range of the worksheet is selected each time i call this sub?
Reply With Quote
