| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: Too many cell formats
Howdy All
I'm receiving an error when i am copying sheets into a workbook What happens is, we have around 200 workbooks each containing one sheet This sheet contains a small amount of data. The only formatting on the sheet is font, font size, and borders The macro i have, copies via paste-specialvalues the contents of each workbook to a new sheet , in one central workbook I have also tried just copying the sheet itself However after copying a around 20/30 sheets it errors out saying "Too many cell formats" I'm getting frustrated as i've seen other workbooks, with hundreds of pages with formatting galor, that easily outnumbers the megar formatting i have in my workbooks Does anyone know of a way around this problem Thanks and cheers AL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Too Many Different Cell Formats (Different than others have | Excel Discussion (Misc queries) | |||
| too many different cell formats error | Excel Discussion (Misc queries) | |||
| error message: Too many different cell formats. | Excel Discussion (Misc queries) | |||
| ERROR: Too many cell formats | Excel Discussion (Misc queries) | |||
| I get an error message "Too many different cell formats" | Excel Worksheet Functions | |||
Threaded Mode
