Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding rows | Excel Discussion (Misc queries) | |||
Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Adding new rows | Excel Programming |