Sheet Copy Stops After 16 Times - Macro Help

**JK1234** · 08-06-2009, 10:15 AM

I can run this macro fine as many times as I want to when it is in this workbook. But when I copy these pages in my huge workbook it will only copy 16 times then give me an error after

PHP Code:


Sheets(s_ws_template).Copy After:=Worksheets(ActiveWorkbook.Sheets.Count)

Anything I can look for somewhere else? My book is too big to put here.

**JK1234** · 08-06-2009, 10:16 AM

Attaching file here

**royUK** · 08-06-2009, 10:18 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**JK1234** · 08-06-2009, 10:43 AM

Is there a limit to the number of tabs??? I went through every page and cant find out why it does this still???

hmmmm.....I have been looking here at older posts and still can not find anything...I'm looking......