Run-time error '6': Overflow

When I run larger files of infomation in the below code I get the Run-time error '6': Overflow. The debugger goes to this line of code: "Sheets(cell.Value).Activate"

The macro copy and pastes a lot of data, so I tried inserting "Application.CutCopyMode = False" but that is not fix it. I am not sure what to do to fix it the error.

The macro is too long to be pasted in here, so I attached it as a txt file.

Thanks.

There are a bunch of cells selected when it happens, specifically E2:E261. The macro only runs up to E258 and the last 3 lines do no get run.

I think you're hitting the upper limit of the number of sheets allowed, but I'm puzzled as to why it throws the error when you activate the sheet, rather than when you create a copy of it.

I run the macro and it creates a new sheet and a pdf file at the same time. When I get to what would be the 65th pdf file I get the error.

I reckon maybe

Please Login or Register  to view this content.

JosephP,

Where do you think that I should insert that? Thanks.

It replaces the line where the error is happening now.

It stopped the error, and exported the correct number of files, but the 2 extra files that were created were just duplicates of file #64.

Can't see why that would be unless the sheets are the same, or the last cells have the same number in them.