Empty Cells

The best way to test if a cell is empty is to use the IsEmpty() function.

If VBA.IsEmpty = False Then 

Testing for a zero-length string will be true when a formula returns a zero-length string

If rgeCell.Value <> "" Then 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext