Hi,
If the cells are empty you can use the following method also in Excel.

Select the range.
Select Edit/GoTo/Special...
Select Blanks.
Click Ok
Type = and press UpArrow key
Press Ctrl+Enter

You can then value paste the cells.
--
Anant


"hccatmo" wrote:

Good afterning,
I have:
A B ............
1 Me You
2 " You
3 " "
4 Her "
. " "
.
.
.
Like to get
A B ............
1 Me You
2 Me You
3 Me You
4 Her You
. Her You
.
.
.

I have seen it done by changing to R1C1 and =R[-1]C but it does not work on
mine desktop? Thx.
cg