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???
GolangMicrosoft ExcelMicrosoft Office
Last Comment
Rob Henson
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
29167299.xlsm
You can add a ListRow like this.Say as Row 7
ListObjects(1).ListRows.Add 7
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.