I have a worksheet with some cells in a column blank. Where that happens I
want to replace the blank with whatever is in the cell directly above, at
least within a range. I've looked around here and in Excel Programming and
there seems to be an idea to put the formula "=R[-1]C" in those blank cells.
I try, but I still get the formula even when I F9. If I use "=" followed by
the id for the cell above it works, but not this relative addressing.
Any thoughts appreciated.