Range("A1").Formula = "=A2*A3"


--
Regards,
Tom Ogilvy

"Simon" wrote in message
...
Hi All,

I'm very new to writing Macro's in excel, what I want to know is If I
have
a macro which tells excel that Cell A1 = Cell A2 * Cell A3. Then is it
possible that once the macro executes that the result is shown in cell A1
and
if you click on cell A1 you can also see the formula i.e =A2*A3, rather
than
just being able to see the result which is how it is at the moment.

Thanks.
Simon