use a worksheet change event that adds the row when the last field in the
current row is filled in.

--
Don Guillett
SalesAid Software

"Clare" wrote in
message ...

Beginner
Hi!
I have a form that enters new information from the user into a
spreadsheet. However, i want a new row added automatically everytime a
new record is added.
Is this possible to add a row using VBA code?
Thanks in advance


--
Clare
------------------------------------------------------------------------
Clare's Profile:
http://www.excelforum.com/member.php...o&userid=36047
View this thread: http://www.excelforum.com/showthread...hreadid=558384