Adding New Rows in VBA
 

I've created a user form to input data into a table. I need it t
create a new row at the top of the table and insert the data entere
into the form into that new row. Is there a way to do that

--
Message posted from http://www.ExcelForum.com

Adding New Rows in VBA
 

The easiest way is to 'name' the column heading, and then get VBA to goto the
name, come down one row, then insert a row and make your entry.
The beauty of doing this is that it is bullet-proof against users inserting
rows above column headings. If you need example code - come back

M

"Captainski009 " wrote:

I've created a user form to input data into a table. I need it to
create a new row at the top of the table and insert the data entered
into the form into that new row. Is there a way to do that?


---
Message posted from http://www.ExcelForum.com/