copying sheets in workbook limit?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have routine that updates previous workbooks by copying sheets within the
new workbook and getting the old sheet information.

Everything works great, but for some reason after more than 45 sheets are
copied it errors out.

Some of my workbooks contain over 100 sheets.

Is this a memory thing or limit thing?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy cell value from one worksheet to matching worksheet in another workbook 4
Copying cells and formula from closed workbook to all sheets in open workbook 0
copying worksheets in a workbook limit? 1
Macro to copy sheets to another workbook fails after about 45 copi 3
Copy sheet to next un-named Workbook 1
Copy sheets to mulitple workbooks in a directory 2
Copy sheet in a workbook 3
Copy a sheet from one workbook to another 1

Back
Top