how to name a range with vba?
Hi
you need to Set a range
try
Private Sub CommandButton1_Click()
Dim myname As Range
Set myname = Range("b5:b25")
myname.Select
End Sub
S
Britt wrote:
Hi,
I want to name a range of cells with vba.
I tried: range("b5:b25).name="myname"
but this gives an error.
Thanks
Britt
|