-
chart
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?
-
Could you post the workbook please?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules