![]() |
|
#21
|
||||
|
||||
|
OK, try the following:
Code:
Sub TblHiLite()
Application.ScreenUpdating = False
Dim Hdr As Long, S As Long, W As Long, C As Long, R As Long, H As Long
Dim StrTitle As String, StrParms As String, StrRGB As String
'Abort if the cursor is not in a table
If Selection.Information(wdWithInTable) = False Then
MsgBox "The selection is not in a table!", vbOKOnly, "TblHiLite"
GoTo ErrExit
End If
'Get Parameters
On Error GoTo ErrExit
StrParms = Split(Selection.Tables(1).Range.Previous.Paragraphs.Last.Range.Text, vbCr)(0)
C = Trim(Split(Split(StrParms, "=")(1), ",")(0))
Hdr = Trim(Split(Split(StrParms, "=")(2), ",")(0))
StrRGB = Trim(Split(StrParms, "=")(3))
S = RGB(Split(StrRGB, ",")(0), Split(StrRGB, ",")(1), Split(StrRGB, ",")(2))
On Error GoTo 0
W = RGB(255, 255, 255)
'process the table
With Selection.Tables(1)
If C > .Columns.Count Then
MsgBox "There is no column " & C & " in the table!", vbOKOnly, "TblHiLite"
End
End If
If Hdr > .Rows.Count Then
MsgBox "There is no row " & Hdr & " in the table!", vbOKOnly, "TblHiLite"
End
End If
StrTitle = Split(.Cell(1 + Hdr, C).Range.Text, vbCr)(0)
.Rows(1 + Hdr).Shading.BackgroundPatternColor = W: H = W
For R = 2 + Hdr To .Rows.Count
If Split(.Cell(R, C).Range.Text, vbCr)(0) <> StrTitle Then
If H = W Then H = S Else H = W
StrTitle = Split(.Cell(R, C).Range.Text, vbCr)(0)
End If
.Rows(R).Shading.BackgroundPatternColor = H
Next
End With
Application.ScreenUpdating = True
End
ErrExit:
MsgBox "Invalid Parameter", vbExclamation
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Macro to highlight a list of words
|
bakerkr | Word VBA | 4 | 10-19-2017 02:23 PM |
Word 2010 VBA Print Macro - Specified Sections
|
Benbon | Word VBA | 3 | 03-30-2017 02:31 PM |
Macro Question: Need help making a macro to highlight the first word in every sentence
|
LadyAna | Word | 1 | 12-06-2014 10:39 PM |
Macro to highlight words
|
bertietheblue | Word VBA | 9 | 07-01-2013 12:39 PM |
| find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |