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:
- 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
- Create a gmail account - Guide
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!
