Defined name range

Defined name range

Post by Billabon » Tue, 05 Oct 2004 10:57:48



Hi,

If I have defined a name for a range (Name > Defined ) in excel, ho
would I call that Name on VBA. For e.g.
Defined name range in excel = DataRange
If I use the code
Range(DataRange).Select
This give me object error.

BR,
Bil
 
 
 

Defined name range

Post by Myrna Lars » Tue, 05 Oct 2004 11:11:26

Range("DataRange").Select

or

Dim sRangeName AS String
sRangeName = "DataRange"
Range(sRangeName).Select

On Sun, 3 Oct 2004 20:57:48 -0500, Billabong

 
 
 

Defined name range

Post by Tom Ogilv » Tue, 05 Oct 2004 11:17:04

Range("DataRange").Select

--
Regards,
Tom Ogilvy



http://www.yqcomputer.com/
 
 
 

Defined name range

Post by duan » Tue, 05 Oct 2004 11:20:23


range("datarange").selec
 
 
 

Defined name range

Post by Billabon » Tue, 05 Oct 2004 12:09:49


Hi Myrna,

Well, that seems easy. Thanks and more power!!!

BR,
Joh