ExcelBanter - View Single Post - Getting the value from a cell, and then using it as a name or R1C1 reference

Thread: Getting the value from a cell, and then using it as a name or R1C1 reference

View Single Post

#2

Report Post

Posted to microsoft.public.excel.programming

Rob van Gelder[_4_] Rob van Gelder[_4_] is offline

Rob van Gelder[_4_] is offline

external usenet poster

Posts: 1,236

Default

Getting the value from a cell, and then using it as a name or R1C1 reference

Sub test()
ActiveWorkbook.Names.Add Range("A1").Value, "=Sheet1!$B$1"
End Sub

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Art" wrote in message
...

Reply With Quote

Reply With Quote