very simple question, but i am stuck. i wish to see if a range is empty.
that's it.

If IsEmpty(Range("a16:a31")) Then
msgbox "all cells are empty"
else
msgbox "at least one of the cells are NOT empty"
end if

this doesn't work for some reason, even though every cell from a16:a31 are
clearly blank. it comes back as false, thus the latter statement pops up.
help. thanks, mike allen