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.
Thanks in advance
Please Login or Register to view this content.
declare your Integer variables as Long instead
by the way this line
declares all the variables except countSecond as Variant and not IntegerPlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi Joseph,
Thanks a lot.It's working as expected.U Rock's.
you're welcome :-)
please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks