I think your problem is that an empty cell does not have the value of
"".

Activecell.ClearContents
? isempty(ActiveCell)
True
? ActiveCell.Value = ""
True
? activeCell.Value = 0
True

Guess it does have a value of "", but zero seems to work as well.

--
Regards,
Tom Ogilvy


"duane" wrote in
message ...

I think your problem is that an empty cell does not have the value of
"". Maybe test for value of 0 (zero) if you are looking for an empty
cell.


--
duane


------------------------------------------------------------------------
duane's Profile:
http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=374525