ToolsOptionsEdit, check Extend data range formats and formulas
Depends on your version of Excel

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"katiekay" wrote in message
...
Hello
Can I write a macro to have a formula automatically repeat in each row?
What
I currently do is copy the formulas to the next several rows or use the
fill
handle & drag down several rows. I'd like to have it happen automatically
as
I finish each row. Possible?
Thank you