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?