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

presence of SOMETHING in a range of cells
 

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

--

HTH

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


"MD" wrote in message
...
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