Get cell contents literally through automation

T

Tuyen Hoang

I'm using Excel 2003 and trying to manipulate sheets with "C#" through Excel
automation.
If a cell has been entered with "=3 + 2", is it possible to get this
original string in stead of the calulated one "5"?
I tried <cell>.Formula but this returns "5"
 
R

Rick Rothstein

I don't use C#, so I don't know what the syntax would be; but, in VBA, you
would reference the Formula property of the cell rather than the Value
property. Here is what the VB code would look like...

MsgBox Range("A1").Formula
 

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

Turning off Word-Wrap 1
use content of a cell as an input for a google query and return the URL of the 1st re 0
Need Help with a VBA subroutine 0
Conditional Formatting with VBA 4
If Condition 4
If Condition 0
Excel performance through COM 6
Calling Excel shortcuts from VBA 2

Top