R1C1 to Range
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 |
R1C1 to Range
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 |
R1C1 to Range
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 |
R1C1 to Range
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 |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com