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
- Samsung keypad reset code - Guide
- Samsung volume increase code - Guide
- Battery reset code - Guide
- How to get whatsapp verification code online - Guide
- Usa country code for whatsapp - Guide
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_ValWhere 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