View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grey Newt[_4_] Grey Newt[_4_] is offline
external usenet poster
 
Posts: 9
Default 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/