Identifying a value
 

How, using VB, can you determine the difference between a zero and
blank cell?

Thanks

--
jtrevil
-----------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...fo&userid=1660
View this thread: http://www.excelforum.com/showthread.php?threadid=31502

Identifying a value
 

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