LinkBack URL
About LinkBacks
Two lines like this ought to do it for you:
currentsheetnum = Application.WorksheetFunction.Substitute(ActiveSheet.Name, "Week", "") NewSheetName = "Week" & currentsheetnum + 1
Two lines like this ought to do it for you:
currentsheetnum = Application.WorksheetFunction.Substitute(ActiveSheet.Name, "Week", "") NewSheetName = "Week" & currentsheetnum + 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks