Over Flow Error when copying columns

Hello,

I'm running into an Over Flow Error when trying to execute the code below. Could anyone help me with this.

Thank you so much

Please Login or Register  to view this content.

I did not get an error when I test it.

AB33 Thanks for your quikc reply.
I have attached the workbook that is giving me problems.

Please take a look at it and see if you are getting the same error. If not it must be something deeper into my other code.


Thank you

You have -688538 in row E-117, hence the overflow error.

It almost seems as if anything passed row 114 is too much for the system. When I go in and delete 115 and beyond it clears up the error for the Over Flow.

You can use

Please Login or Register  to view this content.

It will skip the row which has overflow problem, but not recommend. It does not address the underlying issue, but mask it.
Here is the link to overflow.

http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx

If you convert -688538 in to -68853 (By removing the last digit), the code does not error.

AB33 You Genius!!!!

Ok see why it was posting the error! Thank you so much!