Creating a macro [Closed]

Report
-
Posts
5
Registration date
Tuesday February 24, 2009
Status
Member
Last seen
February 25, 2009
-
Hello,

I would like to know, how to copy a word and paste it into another cell using macro?

1 reply

Posts
5
Registration date
Tuesday February 24, 2009
Status
Member
Last seen
February 25, 2009
19
This will copy what is in Cell B5 and paste it into B8. To change the cells to what you need, simply change the cells in the macro.

Sub CopyPaste()
'
Range("B5").Select
Selection.Copy
Range("B8").Select
ActiveSheet.Paste
End Sub

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!