I can't seem to figure out how to paste a name onto a tab in vba. In regular excel I can use use the ctrl and v option. But, how would you write to paste a copied name on a tab through a macro?
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/21/2009 by test
'
'
Windows("Test's Team (Individual Monthly).xls").Activate
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(1)
Windows("Test's Team (By Group).xls").Activate
Sheets("Monthly Logged Details").Select
Range("A2").Select
Selection.Copy
Windows("Test's Team (Individual Monthly).xls").Activate
ActiveSheet.Paste
Sheets("Template (2)").Select
Sheets("Template (2)").Pastevalues
Range("A1:N1").Select
Windows("Macro.xls").Activate
Range("A1").Select
End Sub
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/21/2009 by test
'
'
Windows("Test's Team (Individual Monthly).xls").Activate
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(1)
Windows("Test's Team (By Group).xls").Activate
Sheets("Monthly Logged Details").Select
Range("A2").Select
Selection.Copy
Windows("Test's Team (Individual Monthly).xls").Activate
ActiveSheet.Paste
Sheets("Template (2)").Select
Sheets("Template (2)").Pastevalues
Range("A1:N1").Select
Windows("Macro.xls").Activate
Range("A1").Select
End Sub