muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i want to check if range blank or not blank fro m range D2:BU1000
this code not work properly how to fix it
thanks in advance
susanto
i want to check if range blank or not blank fro m range D2:BU1000
this code not work properly how to fix it
VBA Code:
Sub CheckIfCellIsEmpty()
Dim isMyCellEmpty As Boolean
isMyCellEmpty = IsEmpty(Range("D2:BU1000"))
If isMyCellEmpty = False Then
MsgBox "NOT EMPTY"
Else
MsgBox "EMPTY"
End If
End Sub
thanks in advance
susanto