I am working on some code in an excel module using IsEmpty. I copied some code from an example and the problem still exists. The code is
Sub TestCellA1()
'Test if the value is cell A1 is blank/empty
If isempty(Range("A1").Value) = True Then
MsgBox "Cell A1 is empty"
End If
End Sub
Note that isempty is all lowercase and not as it should be, I have searched all of the worksheets listed under the project viewer Microsoft Excel Objects, and there is no code under any of the worksheets. I have also checked all of the worksheets for occurrences IsBlank and IsEmpty and there are none.
I am at a lost as to what else to look at.
Thanks
Louis
Sub TestCellA1()
'Test if the value is cell A1 is blank/empty
If isempty(Range("A1").Value) = True Then
MsgBox "Cell A1 is empty"
End If
End Sub
Note that isempty is all lowercase and not as it should be, I have searched all of the worksheets listed under the project viewer Microsoft Excel Objects, and there is no code under any of the worksheets. I have also checked all of the worksheets for occurrences IsBlank and IsEmpty and there are none.
I am at a lost as to what else to look at.
Thanks
Louis