Ed Raymond
New Member
- Joined
- Mar 2, 2005
- Messages
- 16
Hello,
New to VBA, why are the following lines a type mismatch?
Set Impact = Worksheets("Sheet2").Range("C4:C38")
If Impact = Empty Then
MsgBox "No Calculation Possible", vbExclamation
When I run debug, the MsgBox line gives me the error.
New to VBA, why are the following lines a type mismatch?
Set Impact = Worksheets("Sheet2").Range("C4:C38")
If Impact = Empty Then
MsgBox "No Calculation Possible", vbExclamation
When I run debug, the MsgBox line gives me the error.