Thread: accessing value of a cell having formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ashishprem[_7_] ashishprem[_7_] is offline
external usenet poster
  
Posts: 1
Default accessing value of a cell having formula

Hi All,
I wrote one formaula for a cell say (A3) which calculates the sum of
cells A1 and A2
When i am going to access the value of cell A3 it is giving the value
as =SUM(A1:A2) but i want the summation value.
Is there any way to access the value of cell.
I am accessing the value using .Cells(3, 1).FormulaLocal
Please help me out..
Regards,
Ashish


--
ashishprem
------------------------------------------------------------------------
ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485
View this thread: http://www.excelforum.com/showthread...hreadid=516095

Reply With QuoteReply With Quote