quick way to know empty cells in range?
 

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

quick way to know empty cells in range?
 

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

quick way to know empty cells in range?
 

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