Creating a macro

Closed
mike - Feb 11, 2009 at 08:41 AM
Oterwill
Posts
5
Registration date
Tuesday February 24, 2009
Status
Member
Last seen
February 25, 2009
- Feb 25, 2009 at 06:42 AM
Hello,

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

1 reply

Oterwill
Posts
5
Registration date
Tuesday February 24, 2009
Status
Member
Last seen
February 25, 2009
19
Feb 25, 2009 at 06:42 AM
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
0