Null?

[Kura of Tyren]

What does the visual basic portion of excel use to
signify a cell with no contents? I'm trying to make sure
that all cells with no content are set to black as their
font color.

 

[Frank Kabel]

Hi
one way:
if activecell.value="" then
.....

 

[Peter Beach]

Hi,

One way is something based around:

If IsEmpty(Range("A1")) Then
. . .
End If

HTH

Peter Beach