PDA

View Full Version : chart



fraser5002
12-18-2008, 03:10 AM
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?

Benzadeus
12-18-2008, 08:52 AM
Could you post the workbook please?