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.