macro to open hyperlinks with delay is overflowing on iteration

see attached code for running a macro. code is overflowing and only opening a few links instead of 50 at a time for example.

this overflows at 32000 (iteration 14)

lngDelay = (10 + (intLoopcnt \ 2)) * 2000
ALL-MACROS.xlsm
finnstoneAsked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
Not sure about the problem with the links but the overflow could be because you've declared intLoopcnt as Integer, try declaring it as Long instead.
  Dim objCell As Range
  Dim intLoopcnt As Long
  Dim lngDelay As Long

Open in new window


PS In general you should always use Long instead of Integer.
0
 
finnstoneAuthor Commented:
THANKS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.