how to name a range with vba?
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 |
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 |
how to name a range with vba?
ActiveSheet.Names.Add Name:="MyName", RefersTo:="=$B$5:$B$25"
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 |
how to name a range with vba?
Sub NameRange()
Range("B5:B25").Select ActiveWorkbook.Names.Add Name:="MyRange", RefersToR1C1:= _ "=Sheet1!R5C2:R25C2" End Sub Vaya con Dios, Chuck, CABGx3 "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 |
how to name a range with vba?
Thanks to all ..
"CLR" schreef in bericht ... Sub NameRange() Range("B5:B25").Select ActiveWorkbook.Names.Add Name:="MyRange", RefersToR1C1:= _ "=Sheet1!R5C2:R25C2" End Sub Vaya con Dios, Chuck, CABGx3 "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 |
how to name a range with vba?
You missed a double quote:
range("b5:b25).name="myname" should be range("b5:b25").name="myname" 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 -- Dave Peterson |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com