naming a relative range
Posted by Robert Panetta on January 08, 2002 9:01 AM
I need to name a range that stops at a relative point, i have a counter for data rows. I find that I can only name ranges in a RC reference (ie. A1:E3) I need to name a range using this form of code: cells((1,1):(c,4)) . Hopefully someone can help. Thanks, Bob
Posted by Gary Bailey on January 08, 2002 11:23 AM
In VBA try
Range(Cells(1,1),Cells(c,4))
In Excel proper use the Address function.
Gary
