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

accessing value of a cell having formula
 

Ashish,

I think you have actually got too much there, .Cells(3,1) will return the
result of the sum.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"ashishprem" wrote:


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