Hi,
In vba i want to check if there is data in cells in a range. The problem is that in some cells within that range there are formulas that returns nothing (like: ""). So the range is visual empty because the formula returns nothing.
I tried with this but it does not work:
So i want my code to stop if there is any data in one of the cells but the code has to ignore formulas that returns ""
Thanks to think with me..
In vba i want to check if there is data in cells in a range. The problem is that in some cells within that range there are formulas that returns nothing (like: ""). So the range is visual empty because the formula returns nothing.
I tried with this but it does not work:
VBA Code:
Sub TestThisCode()
Dim Cell As Range
For Each Cell in Range("B10:E15")
If Cell.Value = True Then
Msgbox "Not all Empty"
GoTo stop
Else
Msgbox "All Empty"
End If
Next Cell
Stop:
End Sub
So i want my code to stop if there is any data in one of the cells but the code has to ignore formulas that returns ""
Thanks to think with me..