=R[-1]C fails

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.

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)

"Astro Tom" <AstroTom@discussions.microsoft.com> wrote in message
news:90519DAE-C798-4083-BB95-24C920BC648C@microsoft.com...
> 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.

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

--
Kind regards,

Niek Otten

"Astro Tom" <AstroTom@discussions.microsoft.com> wrote in message news:90519DAE-C798-4083-BB95-24C920BC648C@microsoft.com...
|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.