Please Login or Register  to view this content.
This is a piece of code Mr. Jeff B helped me with on a separate subroutine that I'm modifying slightly to do something similar. I've changed the filter parameters from filtering for a color in column k to filtering for "real" blanks in column R. Filter column R for blanks, then fill in a formula to apply to cells that were blanks in between rows with data. I think what it's doing is applying the formula to the entire column instead of just the blanks that were in between rows (real blanks). I also think the non-real blanks are interfering with the resume on error section of the code.