RANDOM row?

Discussions and Tech Support related to automating the iMacros Browser or Internet Explorer from any scripting and programming language, such as VBS (WSH), VBA, VB, Perl, Delphi, C# or C++.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information:CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
sdtony
Posts: 31
Joined: Tue Dec 13, 2005 6:15 am

RANDOM row?

Post by sdtony » Mon Jan 02, 2006 11:59 pm

I would like to audit results of a vba macro (which calls IM). The excel macro works well but the web page is a bit unstable so I'd like to audit the extracted values randomly. The excel macro incorporates:

totalrows = ActiveSheet.UsedRange.Rows.Count
For row = 2 To totalrows
......
......
Next row

to loop through each row and perform the commands including calling a few internet macros. I'd like to run it for 100 randomly selected rows now instead of all the rows. Any suggestions?
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Post by Tech Support » Wed Jan 04, 2006 4:31 pm

One idea would be to use
For row = 2 To totalrows STEP 3
Of course, that is not random but at least reduces the number of loops. You can also change the step interval and/or the start row randomly.
Post Reply