Replace empty or " with content of cell above, using R1C1
 

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

Replace empty or " with content of cell above, using R1C1
 

What part of the answers given in the Worksheet Functions forum where you
also posted this is not working. Are you looking for a VBA solution??? Why
the new thread in this forum...
--
HTH...

Jim Thomlinson


"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

Replace empty or " with content of cell above, using R1C1
 

One way:

Sub BlankRepeats()
For Each cell In Range("A1:B7")
If cell.Value = "" Then cell.Value = cell.Offset(-1, 0).Value
Next cell
End Sub

Regards,
Paul

"hccatmo" wrote in message
...
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

Replace empty or " with content of cell above, using R1C1
 

If you change your desktop cell reference style to R1C1 then =R[-1]C will
work when placed in the empty cells. The Excel defaut cell referemce style
is A1.

"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

Replace empty or " with content of cell above, using R1C1
 

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