Most valuable professional
  • Hot Topics

Excel Highlight blank cells

Hi excel gurus, 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 End Please can someone help ??

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of October 7, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel