Thread: is blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John in Wembley John in Wembley is offline
external usenet poster
 
Posts: 26
Default is blank

Hi team

I wish to look at a cell value and take action if empty / blank

If ActiveCell.Offset(5, 2).Value is blankThen MsgBox ...

Ive had no luck with is null or is blank
What simple solution am I missing, Ive trolled the help file (honest!)

Thanks
John