There is NO value in Range("K5") but the following code does NOT produce the MsgBox:
Sub test()
With Worksheets("Table1")
If Len(.Range("K5").Value) = 0 Then
MsgBox "Cell is Empty"
End If
End With
End Sub
This is the weirdest thing I have ever had with VBA. Please help!!!
Bookmarks