I am sure there is a better way, but this seems to work
Debug.Print Range(Cells(1, 1).Address & "," & Cells(2, 2).Address & ":"
& Cells(3, 3).Address).Address
obviously you put you variables in there
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"waveracerr " wrote in message
...
I am trying to develop a dynamic macro that will adjust a given range
based on several variables. The idea is as follows:
ActiveChart.SetSourceData Source:=Sheets("12 15 03 07
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 use
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 two
instances of cells.
thanks!
---
Message posted from http://www.ExcelForum.com/