Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
when a cell is empty do not consider it at all
I have a program I made for points which I used (if and) format, which I will
enter a different number each time, where the empty cell I don't want to be considered as zero thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
when a cell is empty do not consider it at all
lets see the formula -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=531219 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
when a cell is empty do not consider it at all
You can check if a cell is empty with
for each cell in Range("A1:A10") if isempty(cell) then ' cell is empty else ' cell is not empty end if Next -- Regards, Tom Ogilvy "empty cell" <empty wrote in message ... I have a program I made for points which I used (if and) format, which I will enter a different number each time, where the empty cell I don't want to be considered as zero thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Finding next empty empty cell in a range of columns | Excel Programming | |||
Empty cell and a the empty String | Excel Programming |