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
- Spell number in excel without macro - Guide
- Create a yahoo email account for free - Guide
- Create a snapchat account - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Macro excel download - Download - Spreadsheets
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
