Help creating a Macro
Closed
NanduB
Posts
1
Registration date
Tuesday 24 July 2018
Status
Member
Last seen
24 July 2018
-
24 Jul 2018 à 13:00
Blocked Profile - 24 Jul 2018 à 16:29
Blocked Profile - 24 Jul 2018 à 16:29
Related:
- Nandub
- Creating a discord bot - Guide
- How to run a macro in excel - Guide
- Run Macros in Excel: online, shortcuts, VBA - Guide
- How to create a shortcut on desktop - Guide
- It looks like you're trying to create an account for a business, organization or character. please create a facebook page instead. - Facebook Forum
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!
