Forum Discussion
Can I use a list to auto fill sheet tabs?
Can I use a list to auto fill sheet tabs instead of naming them one at a time?
Getting error here
Sheets(ActiveSheet.Name).Name = Sheets("MySheetNames").Range("A" & intLp)
Did you name the worksheet with the names on it "MySheetNames"? If they are on another worksheet you will need to change this reference to the name of your worksheet.
Yes, that was my first mistake. :) I stepped through it and have an error show up at that line.
Well I'll do a compare, I copied yours and replaced mine and it worked, so thank you.
I'll checkout the difference when I got time, now I'm being pulled in a million directions. :)
Thank you again!