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!!