Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying new records | Excel Discussion (Misc queries) | |||
Identifying correct row | Excel Discussion (Misc queries) | |||
identifying text associated with MIN value | Excel Discussion (Misc queries) | |||
Identifying | Excel Discussion (Misc queries) | |||
Identifying #N/A cells | Excel Worksheet Functions |