View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Need macro copy above cell to current

One way:

ActiveCell.Value = ActiveCell.Offset(-1, 0).Value & " P/O"


"Mikey B" wrote in message
...
I need a cell to copy the above cell and paste into the current cell.
It would also help if It could append " P/O" at the end of the newly
pasted
cell.

It might be simple, but I am having a hard time trying to make this work.
Any help would be greatly appreciated.