Link to home
Start Free TrialLog in
Avatar of Patricia Timm
Patricia TimmFlag for United States of America

asked on

inserting a row into a table

I want  insert a row into a table on an excel spreadsheet. I am cutting the row and placing in new row from row 511 to row 534. I do not want to overwrite the rows just insert the cut row. when I cut the row and go to insert cut cells ... I get a message that saysyou cant rearrange cells within a table this way, because it might affect other table cells in an unexpcted way. So I have to insert a row where I want the cut cells to go... then go to the row and cut then paste in the inserted row... Seems like alot of work... Ideas on ways to make easier???
SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can highlight the number of rows (in the table) you want to insert and right click and "insert rows".  This will add the number of rows you need.  Then paste data into the rows.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you want to use VBA then try this workbook. I was unsure what you were cutting and I assume some row in the table.
29167299.xlsm
You can add a ListRow like this.Say as Row 7

ListObjects(1).ListRows.Add 7

Open in new window

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial