Selecting rows for copying via VB script

Hello everyone.

I am trying a little program to see if I could select full rows for copying.

the code i use is as follows

Please Login or Register  to view this content.

that works perfectly as it hightlight rows 3, 5, and 8 but I want to be able to select rows 12, 24, 36, 48, 60, etc....

So I thought I could use a code something like...

Please Login or Register  to view this content.

Please forgive the VB grammar. I know it may be completely wrong as I am a newbie at VB, but I hope that you get the gist of what I want to do.

The error I get is 'Run-time error '1004': method 'Range' of object'_Global' failed.
I believe variables cannot be used in 'Range' functions. Or maybe?????

Also, another option is that I could have an INPUT saying 'What increment do you want to choose rows??'
If the user enters '10', then the rows 10, 20, 30, 40, etc are selected.
Is this also possible??

Thank you very much for looking.

Hi,

One possibility:

Please Login or Register  to view this content.

Hope it helps,

Dom

perhaps this will get you started:

Please Login or Register  to view this content.

Two options...

This will repeat all the way down column A until the last entry:

Please Login or Register  to view this content.

And this will do it x number of times the user specifies:

Please Login or Register  to view this content.

Dom