Excel Hopeful
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 100
I have the code below running. It's suppose to look at range B15:E21, if there are any values in those cells the Message box should pop up. It's not working. Is it because I'm using Used Range?
Code:
With Worksheets("Sheet1")
If WorksheetFunction.CountIf(UsedRange, "") > 0 Then
MsgBox Title:="Error!!", Prompt:="Your are trying to send notification that you have no unfunded issues, however, you have not cleared the data.", Buttons:=vbOKOnly + vbInformation
Exit Sub
End If
End With