I would like to check for condition whether range rng is empty.
I have following code, but it prints "Not Empty" even though that the cells in the range rng are empty.
Can you please hellp me?

Sub testo()
Set rng = Range(Cells(1, 1), Cells(1, 100))
If IsEmpty(rng) = True Then
Debug.Print "Is empty"
Else
Debug.Print "Not empty"
End If
End Sub