Issue in macro getting overflow error

[expert40]

Hi Team,
I wrote a macro to populate values based on static and seconds.
But when i am populating the values to sheet from macro i am getting overflow error.
Some time the code is working for 100 records sometimes 200.No sure what is the problem.
Can any one from the team help me to proceed further.I want the code to work for any value of nearer to 10000.

Please Login or Register  to view this content.

Thanks in advance

[JosephP]

declare your Integer variables as Long instead

by the way this line

Please Login or Register  to view this content.

declares all the variables except countSecond as Variant and not Integer

[expert40]

Hi Joseph,
Thanks a lot.It's working as expected.U Rock's.

[JosephP]

you're welcome :-)

please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')