Overflow error copying cells?

I couldn't find help with a google search, so thought I would try my luck here. I get a runtime overflow error on this line:

Please Login or Register  to view this content.

This error occurs when the worksheet I'm copying the range from, has a long integer.

I don't think I'm using any variables that I can declare as long. Any suggestions?

Hello AussieM8,

I added the code tags for you this time. Please note the rule below regarding their use.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Try:

Please Login or Register  to view this content.

No - Value2 treats all numeric data as Doubles. My suspicion would be that the formatting of your cells was making the Value property into something that was too small for the data - date formats can do this.

Glad to help.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save