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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add new row to table in Excel 2003?
Excel 03 not have AlwaysInsert parameter. take it out and your ok.
"oli merge" wrote in message ... | 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add new row to table in Excel 2003?
Thanks for the answers both, very helpful.
Homey's suggestion worked and I was able to add a line to the bottom of my table/list (I think its called a list in 03 and is a table in 07?). Deleting was suprisingly straightforward too, just a case of "Selection.Rows.EntireRow.Delete" to delete the selected row. Thanks! |
Reply |
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) |