Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Dale,
Since you declare oSave_Del_Rng as a Range object (and set it using Set ... = ...), the object variable contains a reference to the Range object you set it to [in this case, oSave_Del_Rng is the same as typing Range("Q215")]. Since the default property of a Range object is Value, you will get the value of the range Q215 when you refer to your variable. To get the address, you can use the Address property: Debug.Print oSave_Del_Rng.Address Regards, Jake Marx MS MVP - Excel "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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving as variable file name | Excel Discussion (Misc queries) | |||
variable range | New Users to Excel | |||
Variable range in VB | Excel Discussion (Misc queries) | |||
Variable in Range | Excel Discussion (Misc queries) | |||
Saving Registry variable to ini file | Excel Programming |