View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
 
Posts: 130
Default Macros - How to tell if cells in a column are blank?

Paul B wrote:
Natasha, "I want to identify where column A contains a null value" by null
do you mean 0 or blank or both? . . .


Or something else? Some of the possibilities a

#NULL!, Empty, the empty string (i.e., =""), 0, ', a blank space,
Left("A",0)

Alan Beban