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