Moving cell text

Mar 14th, 2002, 07:09 AM

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

Derek · Mar 14th, 2002, 07:43 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 07:09 AM	#1
Guest Posts: n/a	Question: Is there a formula or a macro to move the text of a cell to another cell? Thanks in advance

Mar 14th, 2002, 07:43 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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