is blank

  • Thread starter Thread starter John in Wembley
  • Start date Start date
J

John in Wembley

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
 
Sub ifblank()
If Len(Application.Trim(ActiveCell.offset(5,2))) < 1 Then MsgBox "empty"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Vba workout if a selection is part of a group? 0
Do Until or For Loop 3
VB code for Excel sheet 10
Check to see if cell is blank 5
If Cell in Column C is Blank, Make Adjacent Cell in Column B Blank 6
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Insert row after blank cell encountered 6
End(xlDown) giving me blanks 1

Back
Top