Macro to repeat formulas in next row

[Guest]

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

 

[Niek Otten]

Tools>Options>Edit, check Extend data range formats and formulas
Depends on your version of Excel

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Ron de Bruin]

See
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Or use a DataForm
http://j-walk.com/ss/dataform/index.htm

 

[Guest]

I checked out your suggestion, and that box was already checked. However, my
formulas still don't carry to the next line.

 

[Peo Sjoblom]

After you have entered the formula you can just press ctrl + d to fill down
the formula