Macro code
Closed
Shekiah
Posts
1
Registration date
Wednesday July 6, 2016
Status
Member
Last seen
July 6, 2016
-
Jul 6, 2016 at 05:50 PM
Blocked Profile - Jul 6, 2016 at 06:11 PM
Blocked Profile - Jul 6, 2016 at 06:11 PM
Related:
- Macro code
- Cs 1.6 code - Guide
- Samsung volume increase code - Guide
- Battery reset code - Guide
- Ninja up code ✓ - Android Forum
- Nokia 105 games unlock code free ✓ - Nokia Forum
1 response
So, have you manually recorded the macro? Try it, it is pretty neat!
Here loop through this:
RANGEVAL[1]
selection.copy
Sheet_name_[1]
Sheet_Name_Val
This is what it looks like from the editor, untouched!
Here is the end result of the above macro:
It's kind of fun to do the impossible! -Walter Elias Disney
Here loop through this:
Range(RANGEVAL[1]).Select
Selection.Copy
Sheets.Add After:=ActiveSheet
Sheets(Sheet_name_[1]).Select
Sheets(Sheet_name_[1]).Name = Sheet_Name_Val
Where a variable is assigned to:
RANGEVAL[1]
selection.copy
Sheet_name_[1]
Sheet_Name_Val
This is what it looks like from the editor, untouched!
Sub Macro2()
'
' Macro2 Macro
'
'
Range("B6").Select
Selection.Copy
Sheets.Add After:=ActiveSheet
Sheets("Sheet3").Select
Sheets("Sheet3").Name = "Fred"
End Sub
Here is the end result of the above macro:
It's kind of fun to do the impossible! -Walter Elias Disney
