Thanks Aladin...that worked!

Larry

"Aladin Akyurek" wrote:


That option has nothing to do with formula copying. If you are not on
Excel 2003, you have to copy down/across the formulas either manually
or by means of code in VBA.

If you are on Excel 2003, change the area with data and formulas into a
list by invoking Data|List|Create List. Excel will copy down the
formulas automatically when appropriate.

Larry F Wrote:
Even after checking this box under Tool-Options-Edit the formulas will
not
automatically copy down my formulas when adding news rows. The formulas
are
in the precedding 25 rows. Any ideas why this is not working?

Thanks
Larry


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=278061