this may be a solution if you want to avoid vba

if your target cell is C7, type in C8
=IF(C7="",0)
then copy C8 to C7
if C7 has somevalue the C8 will give "false"

is this what you want?

cliee cliee wrote in message
...
I want to make a condition ( if the cell is empty) to do something......

If ActiveSheet.Range("A6").Value = 0 Then .......

value = 0 do not mean the cell is empty

do you know how ?

thanks


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!