Adding New Rows in VBA

C

Captainski009

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
 
G

Grey Newt

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
 
Top