/BASIC/Excel vba chck that the range is empty

Excel vba chck that the range is empty

Sub TestIsEmpty()
    If WorksheetFunction.CountA(Range("A38:P38")) = 0 Then
        MsgBox "Empty"
    Else
        MsgBox "Not Empty"
    End If
End Sub

Source: stackoverflow.com

Similar codes

0 vote192 views1 answer
Remove button selection outline visual basic
BASIC
0 vote202 views6 answers
C++ to c converter online
BASIC
0 vote186 views1 answer
Como colocar aspas duplas em vbnet
BASIC
0 vote179 views1 answer
How to close form in vb.net
BASIC
0 vote199 views1 answer
New list VB
BASIC
0 vote197 views2 answers
Get next/previous record
BASIC
0 vote215 views1 answer
Hello world in basic
BASIC
0 vote194 views1 answer
Empno and marks html tables
BASIC
0 vote187 views1 answer
Resttemplate authorization basic
BASIC
0 vote195 views2 answers
Bash catch ctrl-c in a script
BASIC