Dave,
I use a version of this code to examine the "white space" in a file to
see if it is empty- if empty, I delete that range, and reduce file
size. So if the code locates a cell that is populated either with a
number or formula, it moves the cell pointer to that cell so I can
determine if that ce
Hi,
The logic appears to be a bit weird:
If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then
Range(rCell.Address).Select
Exit Sub
End If
If the first cell in the selected range is not empty, or has dependents, then
that cell is selected, and the sub exits.
What do you actually want the ma
