vba code to transfer text from one cell range to another

[jammoca]

If I have some text or numeric values in cells within the range B1:B30 and I want a copy of that transferred to A1:A30 how would I code for that to happen and where would I put that code ?

I don't want to have formulae in the A1:A30 range as it stuffs up something else I'm doing.

any ideas ?

 

[repairman615]

Hello,

It may be a good opportunity to give the macro recorder a shot. Turn it on, then select the range, copy, then paste to where you would like. Stop the recorder.

Then attach the macro to a button.

See if that works and if you need more help post back.

 

[repairman615]

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Macro3()<br><SPAN style="color:#007F00">'</SPAN><br><SPAN style="color:#007F00">' Macro3 Macro</SPAN><br><SPAN style="color:#007F00">' From the Macro Recorder</SPAN><br><br><SPAN style="color:#007F00">'''Here are the instructions:</SPAN><br><SPAN style="color:#007F00">'Press Alt + F11 to open VBEditor, then Keystrokes ALT - I - M to _<br>'       insert module, paste in this code.  Close the Editor</SPAN><br><SPAN style="color:#007F00">'Insert a button and assign Macro3...Ready to use.  Hope that helps, repairman615</SPAN><br><br>    Range("A1:A30").Select<br>    Selection.Copy<br>    Range("B1:B30").Select<br>    ActiveSheet.Paste<br>    Application.CutCopyMode = <SPAN style="color:#00007F">False</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>