Creating Range Names
 

Can I create a range name based on the value of a cell?

Creating Range Names
 

TroyH,

Sure can!

Sub test()
ActiveWorkbook.Names.Add _
Name:=Range("A2").Value, _
RefersTo:="=Sheet1!$A$1:$D$3"
End Sub


Rob

"TroyH" wrote in message
...
Can I create a range name based on the value of a cell?

Creating Range Names
 

One way:

Range("A1:J10").Name = Range("K1").Value

In article ,
"TroyH" wrote:

Can I create a range name based on the value of a cell?