View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Broad[_3_] Doug Broad[_3_] is offline
external usenet poster
 
Posts: 14
Default vba - check if cell is empty

if IsEmpty(ActiveCell) then msgbox "Cell is empty"



"joao" wrote in message ...

hi,

how can i check if a cell is empty in vba? i am using an if, and would
like to test if the cell is empty or not.

thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/