Question : excel vba chck that the range is empty
Answered by : plamen-grozdanov
Sub TestIsEmpty() If WorksheetFunction.CountA(Range("A38:P38")) = 0 Then MsgBox "Empty" Else MsgBox "Not Empty" End If
End Sub
Source : https://stackoverflow.com/questions/10811121/detect-if-range-is-empty/53196985 | Last Update : Mon, 13 Sep 21