Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add new row to table in Excel 2003?
Hi,
I am designing a spreadsheet in Excel 2007 but trying to keep it backwards compatible with 2003. I have a table which a user will enter data in which I wanted to link to two buttons which will either add a row to the bottom (labelled insert row) or delete the selected row (labelled delete row). I have only got as far as inserting a row so far. The code: "Range("G35").Select Selection.ListObject.ListRows.Add AlwaysInsert:=False" works in 2007 but not 2003 and I cant seem to work out the equivilent code. When I tried recording the action of tabbing down the table to create a new row in Excel 2003 it just cycled back to the top of the table and didnt add a row. I am on a very tight schedule to produce this spreadsheet so any help here would be great, with the deletion of current line as well as this problem. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table in Excel 2003 | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
Printing a table on excel 2003 | Excel Discussion (Misc queries) | |||
Link Excel 2003 named range to Access 2003 Table | Excel Programming | |||
How do I convert a Excel 2003 file into a Word 2003 file (table)? | Excel Discussion (Misc queries) |