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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext