Overflow error

**yjmmay34** · 08-19-2010, 09:30 AM

hi, all. during a run my macro, it occurs Run-time error '6': Overflow . Not sure where is the problem.

Please Login or Register  to view this content.

sorry cannot upload the example file as this is an company confidential information. Can anyone just give a suggestions???
Thank you!

**snb** · 08-19-2010, 09:37 AM

Avoid using select in VBA-code.

Please Login or Register  to view this content.

**DonkeyOte** · 08-19-2010, 10:35 AM

The Overflow will be caused by your use of Integer - change to Long.

**yjmmay34** · 08-19-2010, 11:27 AM

Thank you, ote. you're right, i changed it to long then it can work.

Re: Overflow error