I am trying to develop a dynamic macro that will adjust a given rang
based on several variables. The idea is as follows:
ActiveChart.SetSourceData Source:=Sheets("12 15 03 0
KWSC1_1a").Range( _
"C3:C677,E3:E677"), PlotBy:=xlColumns
I want to adjust the line of code: "C3:C677,E3:E677" to allow me to us
a variable for any reference
eg. use variable to reference "C3"
i've tried to use cells(row,col) feature but cannot use more than tw
instances of cells.
thanks
--
Message posted from
http://www.ExcelForum.com