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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Getting the value from a cell, and then using it as a name or R1C1 reference (https://www.excelbanter.com/excel-programming/296815-getting-value-cell-then-using-name-r1c1-reference.html)

art

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

Rob van Gelder[_4_]

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
...

All times are GMT +1. The time now is 06:57 AM.