Try:

Debug.Print Range("A1").Formula

Hope this helps
Rowan

lithium81 wrote:
Hi,

Is it possible to get the forumla from a cell instead of a the result
of the forumla using VBA/Macros?

e.g. In cell A1 I have the formula B1+C1.

I want to retrieve this formula and furthermore it wud be great if I
could get the values in B1 and C1, but I think once the formula can be
extracted, the rest will be easy.

Thanks!!

Hi,

Is it possible to get the forumla from a cell instead of a the result
of the forumla using VBA/Macros?

e.g. In cell A1 I have the formula B1+C1.

I want to retrieve this formula and furthermore it wud be great if I
could get the values in B1 and C1, but I think once the formula can be
extracted, the rest will be easy.

Thanks!!


--
lithium81
------------------------------------------------------------------------
lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461
View this thread: http://www.excelforum.com/showthread...hreadid=494029

If you want it in a variable then:

dim strFml as string
strFml = range("A1").formula

Regards
Rowan

lithium81 wrote:
Hi,

Thanks! When I do the debug.print, I don't see any output, perhaps I am
using it the wrong way. Could someone help please?

Will this put the data into a variable?

Thanks!

Hi,

Thanks! When I do the debug.print, I don't see any output, perhaps I am
using it the wrong way. Could someone help please?

Will this put the data into a variable?

Thanks!


--
lithium81
------------------------------------------------------------------------
lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461
View this thread: http://www.excelforum.com/showthread...hreadid=494029

Thank you! That works great!


--
lithium81
------------------------------------------------------------------------
lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461
View this thread: http://www.excelforum.com/showthread...hreadid=494029

You're welcome.

lithium81 wrote:
Thank you! That works great!

Hi lithium81,
Debug statement results from VBA code appear on the Intermediate
window in the Visual Basic Editor (Ctrl+G).

For what you want I would suggest the use and flexibility of a
User Defined Function see GetFormula at
http://www.mvps.org/dmcritchie/excel...htm#getformula
if it is not obvious where the formula referenced actually is at,
then a variation GetFormulaD might work better for you.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rowan Drummond" wrote in message ...
If you want it in a variable then:

dim strFml as string
strFml = range("A1").formula

Regards
Rowan

lithium81 wrote:
Hi,

Thanks! When I do the debug.print, I don't see any output, perhaps I am
using it the wrong way. Could someone help please?

Will this put the data into a variable?

Thanks!