hi
is there any quick way to know whether the cells in a range is empty
or not...i mean without looking at each cells..(doing for each cells
in range ........next for)

Thanks for you help.

musa.biralo

Sub well_are_they()
If Application.CountA(Selection) = 0 Then
MsgBox ("they are empty")
End If
End Sub

--
Gary''s Student
gsnu200710


"musa.biralo" wrote:

hi
is there any quick way to know whether the cells in a range is empty
or not...i mean without looking at each cells..(doing for each cells
in range ........next for)

Thanks for you help.

musa.biralo

i don't know what had happened to my first reply...

anyways i was saying thank you...

thank you Mr Gary.
that really helped.

musa.biralo

On Mar 17, 2:22 pm, Gary''s Student
wrote:
Sub well_are_they()
If Application.CountA(Selection) = 0 Then
MsgBox ("they are empty")
End If
End Sub

--
Gary''s Student
gsnu200710

"musa.biralo" wrote:
hi
is there any quick way to know whether the cells in a range is empty
or not...i mean without looking at each cells..(doing for each cells
in range ........next for)

Thanks for you help.

musa.biralo