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
2.1m questions
2.1m answers
60 comments
57.0k users