| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defined name range
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 -- Billabon ----------------------------------------------------------------------- Billabong's Profile: http://www.excelforum.com/member.php...fo&userid=1090 View this thread: http://www.excelforum.com/showthread.php?threadid=26596 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Defined name range
Range("DataRange").Select
or Dim sRangeName AS String sRangeName = "DataRange" Range(sRangeName).Select On Sun, 3 Oct 2004 20:57:48 -0500, Billabong wrote: Hi, If I have defined a name for a range (Name Defined ) in excel, how 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, Bill |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Defined name range
Range("DataRange").Select
-- Regards, Tom Ogilvy "Billabong" wrote in message ... Hi, If I have defined a name for a range (Name Defined ) in excel, how 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, Bill -- Billabong ------------------------------------------------------------------------ Billabong's Profile: http://www.excelforum.com/member.php...o&userid=10904 View this thread: http://www.excelforum.com/showthread...hreadid=265969 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Defined name range
range("datarange").selec -- duan ----------------------------------------------------------------------- duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162 View this thread: http://www.excelforum.com/showthread.php?threadid=26596 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB pre-defined range ? | Charts and Charting in Excel | |||
| Name defined Range - Copy? | Excel Discussion (Misc queries) | |||
| How can I see defined name range? | Excel Discussion (Misc queries) | |||
| Defined range problem | Excel Discussion (Misc queries) | |||
| Defined range difficulty | Excel Discussion (Misc queries) | |||
Hybrid Mode
