Moving cell text

[Guest]

Question:
Is there a formula or a macro to move the text of a cell to another cell?
Thanks in advance

 

[Derek]

Hi

If you have text in A1 which you want in A2, nothing you do in A1 can send it to A2. But in cell A2 you can put this formula =A1

In code you can try this
Range("A2").Value = Range("A1").Value

hope this helps
regards
Derek