/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

1 vote458 views1 answer
How to add basic authentication on haproxy backend server
BASIC
0 vote403 views1 answer
Sequnce function vb.net
BASIC
0 vote393 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
0 vote371 views1 answer
Dos assign command output to variable (when output is of multiple lines)
BASIC
0 vote407 views1 answer
API Key Authentication, Basic , Pasword Grant, Client Credentials
BASIC
0 vote488 views1 answer
Basic latex document
BASIC
0 vote418 views1 answer
Theme leaf concatenate
BASIC
1 vote462 views2 answers
Tmux basic commands
BASIC
2 votes484 views1 answer
Vb string to int32
BASIC
0 vote401 views1 answer
Xolo themeforest
BASIC