Copying data from Access to Excel: "Run-time error '6' Overflow"

Hi everybody,

I've put together a macro, that transfers the data from MS Access database into prepared MS Excel Worksheet.

As a part of this code, I've added the line below:

Please Login or Register  to view this content.

which makes sure, that all the data, that are copied over into the Excel (within the range C10:K100) are formatted as numbers (not formatted as text as would be the case without this line).

However, once I added new quarterly data into the Access database, macro breaks down referring to the line above and giving this error message:

Run-time error '6':

Overflow

Would any of you had an idea, what might be causing these break downs? Before the last update, it worked just fine...

Thank you for any help!