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 :)??
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
This question generated 17 answers. To proceed to the answers, click here.
This thread is current as of October 07, 2014.