Copy Worksheet to new file and rename based on list

[ptmuldoon]

Trying to figure out why I'm getting an error here.

I'm trying to create a new workbook and copy a worksheet XX number of times based on range/list from a column in a table.

Edit. I got it working. Didnt' realize I was mistakenly calling wb2 incorrectly earlier.
Thanks

Please Login or Register  to view this content.

[6StringJazzer]

Thanks for the explanation of your solution. I'm going to close the thread.