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
I wrote some code to search a range of cells to locate non-blank cells
and cells with dependents. (A clever contributor on these forums, Jim
Cone, was pivotal- thank you, Jim!)
I had this code running correctly at one point, but lost the file that
contained the working code. I've tried to recreate
