I want to check if a range in Excel is empty.
How do I write in VBA code:
If Range("A38":"P38") is empty
Found a solution from the comments I got.
Sub TestIsEmpty() If WorksheetFunction.CountA(Range("A38:P38")) = 0 Then MsgBox "Empty" Else MsgBox "Not Empty" End If End Sub
1.4m articles
1.4m replys
5 comments
57.0k users