Defined name range

  • Thread starter Thread starter Billabong
  • Start date Start date
B

Billabong

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
 
Range("DataRange").Select

or

Dim sRangeName AS String
sRangeName = "DataRange"
Range(sRangeName).Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error on sorting a range 2
Retrieve pivotitem range 1
Help using indirect addressing in chart series 2
Set Named Range with Last Row 5
Workaround for Excel 2002/2003 UDFs recalculating and changing cel 9
range name define on non active(focused) sheet 10
InputBox to name a range 2
problem:Structure with Object reference (TYPE...END TYPE) 6

Back
Top