Thread: Access Cell name in VBA code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ChrisSroka ChrisSroka is offline
external usenet poster
  
Posts: 1
Default Access Cell name in VBA code

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?


--
ChrisSroka
------------------------------------------------------------------------
ChrisSroka's Profile: http://www.excelforum.com/member.php...o&userid=29168
View this thread: http://www.excelforum.com/showthread...hreadid=488965

Reply With QuoteReply With Quote