Thread
:
empty range
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gary''s Student
external usenet poster
Posts: 11,058
empty range
Sub emptcheck()
For Each r In Selection
If IsEmpty(r) Then
Else
MsgBox ("at least on cell in this range has content")
Exit Sub
End If
Next
MsgBox ("the cells in this range are empty")
End Sub
--
Gary''s Student - gsnu200770
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student