how do you name a range?
Range(Cells(1), Cells(4, 4)).Name = "NamedRange"
RBS
"John" wrote in message
...
I'm very new. How do you name a range? Like give a cell or range a name
rather than use "a1" cells(1,1). All I could find was this:
ActiveWorkbook.Names.Add Name:="SecondTry", RefersToR1C1:= _
"=Sheet1!R8C2:R11C3"
I got this by using record macro. I don't understand it.
thanks
John
|