presence of SOMETHING in a range of cells

Good morning,

How can I put in a simple logic test if a range of cells has anything in
them (numbers or text). Say range("a1:a5") the cell A1 has something in it
then do this... if range(a1:a5") is empty then do that instead...

regards,

Michel

If application.counta(range("A1:A5")) > 0 Then
'...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MD" <[email protected]> wrote in message
news:[email protected]...
> Good morning,
>
> How can I put in a simple logic test if a range of cells has anything in
> them (numbers or text). Say range("a1:a5") the cell A1 has something in
it
> then do this... if range(a1:a5") is empty then do that instead...
>
> regards,
>
> Michel
>
>