Copy, paste append from cell above

M

Maarkr

thought it would be easy but it's not working well... trying to code a small
module to copy the cell above and paste append it to the active cell, but I
need to be able to delete the cell above it, so I can't concatenate it.

ActiveCell.Offset(-1, 0).Select
Selection.Copy
ActiveCell.Offset(1, 0).Select
??
 
L

Luke M

This will create a stand-alone, static value in activecell:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Help with code please 4
Copy and paste 1
Copy & paste special 2
Excel Macro to use cells as a autofilter 0
append all instead of one 5
Pasting in an Excel Macro 2
Can Vba workout if a selection is part of a group? 0

Top