accessing value of a cell having formula

  • Thread starter Thread starter ashishprem
  • Start date Start date
A

ashishprem

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
 
Ashish,

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

Regards,

Chris.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
excel formula 1
Variable SUM range 16
Conditional Sum 1
Summation of the Cells 1
Can a formula do this? 1
some more explanation 11
HELP!!! I can't set formula to cell 1

Back
Top