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