Hi Toppers,

Thanks for the formula but the result is tha in cell "A1" the formula is put
and that is not what i wanted. I would like to have the result of the formula
eg the sum of the column in cell "A1"
Can you help me please?
Thanks,
Jean-Pierre (novice)

Toppers wrote:
Worksheets("Sheet1").Range("a1") = "=SUM(Sheet2!P:P)"

Hi,
I'am a novice on VBA programming....
[quoted text clipped - 5 lines]

Does anyone have a clue how to do that in VBA ?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200508/1