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.

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