![]() |
|
#2
|
||||
|
||||
|
You might try giving Word some breathing space for its own housekeeping:
Code:
Sub Grey()
Application.ScreenUpdating = False
Dim Tbl As Table, Cll As Cell, i As Long
For Each Tbl In ActiveDocument.Tables
For Each Cll In Tbl.Range.Cells
i = i + 1: If i Mod 500 = 0 Then DoEvents
With Cll
If Split(.Range.Text, vbCr)(0) = "-1" Then
.Shading.BackgroundPatternColor = wdColorGray10
.Range.Text = ""
End If
End With
Next
Next
Set Cll = Nothing: Set Tbl = Nothing
Application.ScreenUpdating = True
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Numbering with heading is mixed up in odd pages in regard to even pages | Baflla | Word | 0 | 09-11-2016 05:25 AM |
| Multiple Master Pages dont sync with content pages | generatorjoe | Publisher | 0 | 07-28-2016 10:12 AM |
| Spreadsheet keeps crashing | SavGDK | Excel | 8 | 06-28-2016 08:27 AM |
Office 2013 is crashing and renaming files when crashing
|
Brewski | Office | 1 | 09-21-2015 09:04 PM |
Advanced page numbering: section pages in header, document pages in footer
|
Albus | Word | 12 | 12-12-2014 01:36 PM |