Trying to get the sheet name to be the cell C1
![]()
Sub New_Shooter() ' ' New_Shooter Macro ' ' Sheets("Blank Form").Select Cells.Select Application.CutCopyMode = False Selection.Copy Sheets.Add After:=c1 ActiveSheet.Paste End Sub
Trying to get the sheet name to be the cell C1
![]()
Sub New_Shooter() ' ' New_Shooter Macro ' ' Sheets("Blank Form").Select Cells.Select Application.CutCopyMode = False Selection.Copy Sheets.Add After:=c1 ActiveSheet.Paste End Sub
Last edited by Jarrettm; 04-17-2015 at 10:42 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks