Help creating a Macro
Closed
NanduB
Posts
1
Registration date
Tuesday July 24, 2018
Status
Member
Last seen
July 24, 2018
-
Updated on Jul 24, 2018 at 01:47 PM
Blocked Profile - Jul 24, 2018 at 04:29 PM
Blocked Profile - Jul 24, 2018 at 04:29 PM
Related:
- Help creating a Macro
- Spell number in excel without macro - Guide
- Create a snapchat account - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Create a yahoo email account for free - Guide
- Macro excel download - Download - Spreadsheets
1 response
You shouldn't need help making a macro, you can literally RECORD ONE! Press record Macro, and do the job, then press stop. There you go, a macro!
It should look like this:
After you have recorded it, then you can start to introduce the variables!
It should look like this:
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets.Add After:=ActiveSheet
Sheets("Sheet2").Select
Sheets("Sheet2").Name = "thissheet"
Sheets("Sheet1").Select
Rows("2:12").Select
Selection.Copy
Sheets("thissheet").Select
Rows("6:6").Select
ActiveSheet.Paste
End Sub
After you have recorded it, then you can start to introduce the variables!