Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: nevertoolate
- Order by date
-
overcoming maximum number of iterations
I had my doubts, Bryan, since my app was crashing at 32767, not 32627, but I tried it anyway. And you were RIGHT! Such a simple solution, too. Many, many thanks...- nevertoolate
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
overcoming maximum number of iterations
I have a spreadsheet containing thousands of lines of data that I search to extract data for reports. A current sheet has 43,000 lines, and the vba program crashes after searching 32767 rows. The search is done in a "Do-Loop While" loop, and 32767 is the maximum number of iterations...- nevertoolate
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
