Hi guys,
I want to duplicate a worksheet 10 times, and rename those 10 sheets according to a table of names residing in another spreadsheet. Currently I've written the following code:
Dim iSheetNumber As Long
Dim rNewSheetNames As Range
Dim rName As Range
Set rNewSheetNames =...