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 cell contains useful data.
I tried to expand the idea with that function that would also point out if the cell has dependents elsewhere in the file, and NOT delete that part of the range if the dependents were necessary. My intended logic is: if a given cell is not empty, or if it has dependents, land the cell pointer there for review. I thought I had captured that logic. Do you interpret it otherwise? Thanks, Dave O -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
