| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlght rows
I have a column containing a collection of various numbers. I need to use
code to highlight the rows containing the number 5. I have tried with this but it does not work. For Each Cell In Columns(2) If Cell.Value = "5" Then EntireRow.Select With Selection.Interior .ColorIndex = 15 .Pattern = xlSolid End With End If Not sure why....Help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| "Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows. | Excel Programming | |||
| Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Threaded Mode
