Try IsEmpty() function:

if IsEmpty(Range("A1")) then

HTH
--
AP

"Turquoise_dax"
a écrit dans le message de news:
...

If I want the cells with I:

If cell = "I" Then cell.Offset(0, 2).Interior.Pattern = xlPatternGray8

So How do I refer to Empty cells?

If cell = *EMPTY* Then cell.Offset(0, 2).Interior.Pattern =
xlPatternGray8


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile:
http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=554622