The VBA IsEmpty function you can use if a cell is really empty
Sub test()
If IsEmpty(Range("A1")) = True Then
MsgBox "blank"
Else
MsgBox "not blank"
End If
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"jtrevill" wrote in message ...
How, using VB, can you determine the difference between a zero and a
blank cell?
Thanks!
--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=315026