Why not just put the formula in E9:
=SUM((D2,E2))/2*(365)/J2

Note, you do not need "SUM" and "+". One or the other.

NickHK

"redlion" wrote in
message ...

Sorry NickHK,

All I need is a macro which uses this formula =SUM((D2+E2))/2*(365)/J2
and put the answer in cell E9

Regards


--
redlion
------------------------------------------------------------------------
redlion's Profile:
http://www.excelforum.com/member.php...o&userid=36140
View this thread: http://www.excelforum.com/showthread...hreadid=560934