check a range of cells to see if they are empty
 

I am looking for code that will check a range of cells to see if they
contain any data. If they do, then I know the sheet has been used before
and it is not the first time it is being used.

check a range of cells to see if they are empty
 

This function returns true if range provided as argument is truly empty
(no spaces, formulas, etc).


Function range_empty(rng As Range) As Boolean
Dim cell As Range
range_empty = True
For Each cell In rng
If cell.Formula < "" Then
range_empty = False
Exit For
End If
Next
End Function