find a non-empty cell
Does this help..
Set varRange = Selection.Find("*")
If Not varRange Is Nothing Then MsgBox "Data exist in this range"
--
Jacob (MVP - Excel)
"Valeria" wrote:
Dear experts,
what is the quickest VBA way to determine in a big cells range if at least
one of them is non empty?
Many thanks for your help!
Best regards
--
Valeria
|