Thanks, I'll give that a try.
"Reesey" wrote:
pmms Wrote:
I'm creating a form that will be used for data entry and one cell is
the
product of 2 other cells. If the user needs to insert more lines the
formula
does not carry forward. Any suggestions? Thanks!
I would create a macro (using the macro recorder - that's easiest) that
copies and inserts a line with the formulas in it. Then I would add the
macro to the toolbar and tell end user that they need to insert new
lines via the toolbar command (or you create an 'icon'). This is one
idea - maybe someone out there has a more sophisticated solution.
--
Reesey
------------------------------------------------------------------------
Reesey's Profile: http://www.excelforum.com/member.php...o&userid=36764
View this thread: http://www.excelforum.com/showthread...hreadid=564882