Creating Range Names

[Guest]

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

 

[Rob van Gelder]

TroyH,

Sure can!

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


Rob

 

[JE McGimpsey]

One way:

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

 

[Guest]

Thanks for the reply

This is great news, what would I do if I want to use an Activecell? Can I use a stored value?