Hi John

How about

If ActiveCell.Offset(5, 2).Value ="" Then MsgBox...

//Per

"John in Wembley" skrev i en meddelelse
...
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