=R[-1]C fails

A

Astro Tom

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.
 
B

Bob Phillips

You need to be in R1C1 view for this, Tools>Options>General.

But, it is just the same as entering say =F10 if you are in F11, that is
relative, =$F$10 is not relative.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
N

Niek Otten

To make this kind of addressing work: Tools>Options>General tab, check R1C1 Reference style

--
Kind regards,

Niek Otten

|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.
 
Top