Thread
:
how to add new row to table in Excel 2003?
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_2_]
external usenet poster
Posts: 1,522
how to add new row to table in Excel 2003?
I don't quite understand about your labeling.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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!
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]