Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named ranges
I have text in cell A1. In B1, I want to create a named range = text in A1.
How would I write the code for that? Thanks. Steve C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named ranges
Range("B1").Name = Range("A1")
-- Vasant "Steve C" wrote in message ... I have text in cell A1. In B1, I want to create a named range = text in A1. How would I write the code for that? Thanks. Steve C |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named ranges
Steve
Try something like this Sub SetRngName() ThisWorkbook.Names.Add Name:=Range("A1").Value, _ RefersTo:="=Sheet1!$B$1" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Steve C" wrote in message ... I have text in cell A1. In B1, I want to create a named range = text in A1. How would I write the code for that? Thanks. Steve C |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named ranges
Thanks! That works great!
"Vasant Nanavati" wrote: Range("B1").Name = Range("A1") -- Vasant "Steve C" wrote in message ... I have text in cell A1. In B1, I want to create a named range = text in A1. How would I write the code for that? Thanks. Steve C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming |