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
Oterwill Posts 5 Registration date Tuesday February 24, 2009 Status Member Last seen February 25, 2009 - Feb 25, 2009 at 06:42 AM
Related:
- Creating a macro
- Creating samsung account - Guide
- Creating music apps - Guide
- Excel online macro - Guide
- Excel run macro on open - Guide
- Creating a skype account - Guide
1 response
Oterwill
Posts
5
Registration date
Tuesday February 24, 2009
Status
Member
Last seen
February 25, 2009
19
Feb 25, 2009 at 06:42 AM
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
Sub CopyPaste()
'
Range("B5").Select
Selection.Copy
Range("B8").Select
ActiveSheet.Paste
End Sub
