Access Cell name in VBA code
Try:
Range("F2").value = range("Angle_L").value
Hope this helps
Rowan
ChrisSroka wrote:
In an Excel worksheet I define a cell name as Angle_L. How do I access
the value of the cell with the name Angle_L in VBA code?
In a worksheet I have defined a cell with the name Angle_L and put the
value 10 into it.
I run this code in a VBA macro
Range("F2").Select
ActiveCell.Value = Angle_L
But the cell F2 is filled with the value 0, not the value contained in
the cell named Angle_L.
How can I get this to work?
|