View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.