Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Peculiar Problem when Doing a Sheet.Copy
Excel 2003. I have some code that copies sheet by sheet from one workbook
into another, renaming the sheets as it goes. Even though the source workbook has 80 sheets, the copy never gets past the 58th sheet, then errors out. I have tried using various source workbooks and always bomb at the 58th sheet. It is not a problem with the sheet being copied. Here is the code: For Each sh In TempWb.Sheets 'Copy sh.Copy After:=Workbooks(YTDWbName).Sheets(1) 'Rename YTDWb.ActiveSheet.Name = Mid(YTDWb.ActiveSheet.Name, 1, 27) + "(4)" Next sh What could be my problem? Thanks and God bless for any help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Peculiar Date problem | New Users to Excel | |||
web query peculiar problem | Excel Programming | |||
A peculiar PDF from Excel problem | Excel Discussion (Misc queries) | |||
A peculiar problem | Excel Programming | |||
A peculiar problem | Excel Programming |