I'm trying to set the name of a worksheet using the following code, and it's failing to process for some reason. Can anybody help me out with this?
Sub CreateNew()
intTabs = Worksheets(1).Cells(18, 2).Value
For i = 1 To intTabs
strWsName = InputBox("Please name Sheet" & i & "."...