Saving Range Locatoin into a Variable
 

Dale,

The address is just a property of the range

= Range(sDelivery_Rng).Address

But, this is a string, not an object, so just use

Const sDelivery_Rng = "Q215"
Dim oSave_Del_Rng As String

oSave_Del_Rng = Range(sDelivery_Rng).Address

or just

Const sDelivery_Rng = "Q215"
Dim oSave_Del_Rng As Range

Set oSave_Del_Rng = Range(sDelivery_Rng)
MsgBox oSave_Del_Rng.Address



--

HTH

Bob Phillips

"Dale Cox" wrote in message
...
The following code executes just fine. The value moved
into oSave_Del_Rng, however, is the value in the Cell
Q215. I need the cell address, not the value of the cell,
moved into the variable.
Const sDelivery_Rng = "Q215"
Dim oSave_Del_Rng as Range
Set oSave_Del_Rng = Range(sDelivery_Rng)

Help!