View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hccatmo hccatmo is offline
external usenet poster
 
Posts: 15
Default 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