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
|