testing the value of a cell
 

Curious what the code should look like to test if a cell
is empty of both numbers and letters.

Trying to setup so that If B1 is empty then this else
this.

testing the value of a cell
 

=IF(A1="", "A1 is empty", "A1 is not empty")

Dan E

"Zeraia" wrote in message ...
Curious what the code should look like to test if a cell
is empty of both numbers and letters.

Trying to setup so that If B1 is empty then this else
this.

testing the value of a cell
 

=ISBLANK(A3) where A3 is the cell being tested.

Zeraia wrote:
Curious what the code should look like to test if a cell
is empty of both numbers and letters.

Trying to setup so that If B1 is empty then this else
this.

testing the value of a cell
 

If isempty(range("B1")) then
' this
else
' that
End if

--
Regards,
Tom Ogilvy

Zeraia wrote in message
...
Curious what the code should look like to test if a cell
is empty of both numbers and letters.

Trying to setup so that If B1 is empty then this else
this.