How would I use an excel range with the following
statement instead of the R1C1 formula?

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!R17C1"

For example

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!Range("A1")

TIA

Hi Jahson,

How would I use an excel range with the following
statement instead of the R1C1 formula?

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!R17C1"

ActiveWorkbook.Worksheets("Control").Range("A1").N ame="Drp_Name"

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Jahson,

Worksheets("Control").Range("A1").Name = "Drp_Name"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jahson" wrote in message
...
How would I use an excel range with the following
statement instead of the R1C1 formula?

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!R17C1"

For example

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!Range("A1")

TIA

ActiveWorkbook.Names.Add Name:="Drp_Name", _
RefersTo:="=Control!$A$1"

As another example.

--
Regards,
Tom Ogilvy


"Jahson" wrote in message
...
How would I use an excel range with the following
statement instead of the R1C1 formula?

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!R17C1"

For example

ActiveWorkbook.Names.Add Name:="Drp_Name",
RefersToR1C1:="=Control!Range("A1")

TIA