Syntax error in VB code

[Egirl212]

I have the following syntax error when trying to select multiple rows with VB (jumping 2 rows in between)
Please help.



For i = ("8 To 11") & ("14 To 17")

Thank you!

 

[BrianJN1]

I have the following syntax error when trying to select multiple rows with VB (jumping 2 rows in between)
Please help.



For i = ("8 To 11") & ("14 To 17")

Thank you!

You provide insufficient detail.
I assume that you have need to select rows(8:11) and maybe paste them to rows(14:17) thereby skipping rows 12 and 13.
Even that assumption maybe wrong.

Please be more specific.

 

[Egirl212]

Thank you Brian.
I wanted to select rows from 8 to 11 and from 14 to 17.

You provide insufficient detail.
I assume that you have need to select rows(8:11) and maybe paste them to rows(14:17) thereby skipping rows 12 and 13.
Even that assumption maybe wrong.

Please be more specific.

 

[BrianJN1]

What do you need to do with your selections?
Once you have chosen rows 8-11 what is to happen to them before you choose 14-17?
You are still not telling enough of your story.

 

[dmt32]

Hi,
one way maybe would be to advance your index variable i to skip to next block

e.g.

For i = 8 To 17
    i = IIf(i = 12, 14, i)

'your code


Next i

Dave