![]() |
|
|
|
#1
|
|||
|
|||
|
I don't know how to fix it because I don't know what is not working. You said you have a 11 column table with data always in column 1 and 7. The code I provided you looks at columns 2-6 and 8-11 starting with the last row of the table. If they are all empty then the row is deleted. The first time a row contains content in 2-6 or 8-11 the execution stops. |
|
#2
|
|||
|
|||
|
Hello Greg,
Sorry your code is OK. I forgot a few coulombs with a checkbox. They are count one extra in the form. It doesn't matter or the boxes are on or off.So table 9 is also working fine for deleting empty row's. Thank you again! The under line is also working in table 11 and 15. In table 9 is it working when the whole inner table has a line. In table 9 I want in the middle a blank coulomb because I want a border between the right and left part. (actually it are two tables next to each other). When I do this, the line Selection.Tables(1).Rows.Last.Borders(wdBorderBott om).Color = Selection.Tables(1).Rows.First.Borders(wdBorderTop ).Color isn't working anymore. I tried to fix it to change some codes but ...I'll think I need some help... ![]() The test document is in the attachment. Greetz ViBoR. From a rainy Holland
Last edited by vibor; 05-03-2015 at 05:43 AM. Reason: writing faulth |
|
| Tags |
| empty cell delete row |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Macro to delete all empty rows from all tables
|
braddgood | Word VBA | 15 | 10-02-2015 01:54 PM |
Delete empty cell and shift up
|
Linh | Word Tables | 1 | 09-21-2014 01:52 PM |
| Creating VBA Code to Delete Empty Column in Table | Faugs | Word VBA | 5 | 08-07-2014 03:29 PM |
| Delete lots of empty space between paragraphs. | FieldTechnician | Word | 4 | 10-25-2013 01:14 PM |
Macro to delete rows with all empty cells
|
ubns | Excel Programming | 2 | 08-14-2012 02:01 AM |