excel_2009
Active Member
- Joined
- Sep 14, 2009
- Messages
- 318
Hi excel gurus,
I have the following code which does not work properly, it should highlight cells in one column that are blank:
Please can someone help ??
I have the following code which does not work properly, it should highlight cells in one column that are blank:
Code:
Sub BorderForNonEmpty()
Dim myRange As Range
Set myRange = Sheets("Inventory").Range("A1:A888")
'clear all color
myRange.Interior.ColorIndex = xlNone
'color only blank cells
myRange.SpecialCells(xlCellTypeBlanks).Interior.ColorIndex = 6
End Sub
Please can someone help ??