Thread: How do you refer to empty cells in coding?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Turquoise_dax[_15_] Turquoise_dax[_15_] is offline
external usenet poster
  
Posts: 1
Default How do you refer to empty cells in coding?

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

Reply With QuoteReply With Quote