Null?
 

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.

Null?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Kura of Tyren wrote:
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.

Null?
 

Hi,

One way is something based around:

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

HTH

Peter Beach

"Kura of Tyren" wrote in message
...
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.