Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm creating code that will inform me
of what rows in my range B1:F20 have been highlighted in yellow. Extract... Range("B1").Select For i = 1 To NumRows For j = 1 To NumCols If Rng.Cells(i, j).Interior.ColorIndex = 6 Then Tag = True If Tag = True Then XRow = XRow & "," & CStr(i) End If Next j Next i MsgBox "Rows " & XRow & " are yellow" End Sub Currently my msgbox is displaying: Rows ,3,7,9,9,9,14,18 are yellow. It is correct - Row 9 has 3 cells highlighted - whereas 3,7,14,& 18 have only a single cell HLed. What can I apply to get the msgbox to show Rows 3,7,9,14,18 are yellow Elimination of the leading "," would be a bonus, TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Formulas for...1. Counting unique cells 2. Display unique contents | Excel Programming |