![]() |
|
#5
|
||||
|
||||
|
Hi brad,
Quote:
You could deal with ordinary spaces by changing: If Len(.Rows(i).Range.Text) = .Rows(i).Cells.Count * 2 + 2 Then .Rows(i).Delete to: If Replace(Len(.Rows(i).Range.Text)," ","") = .Rows(i).Cells.Count * 2 + 2 Then .Rows(i).Delete but even this won't delete rows with just non-breaking spaces, tabs, paragraph breaks, etc.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Empty rules
|
rene.kamphuis@ciz.nl | Mail Merge | 21 | 04-15-2011 12:34 AM |
Word Macro to search all tables
|
silverspr | Word VBA | 3 | 04-02-2011 11:20 PM |
| delete email message via blackberry and have it delete on my pop3 and my outlook | Iamthestorm | Outlook | 2 | 10-28-2010 12:21 AM |
I need a macro that removes background of many tables
|
masa57 | Word VBA | 2 | 05-08-2010 07:34 AM |
| Automated "Macro" to delete Tags/Anchors | field3 | Word VBA | 0 | 02-25-2009 02:53 PM |