For...Next Statement won't accept datatype argument

[TylrA]

I'm new to programming and want to make a For loop that selects cells based on the counter:

For indexA = 1 to 10
Range(cells(indexA, indexA + 3)).Select
...
Next indexA

The debugger flags the second line saying "Method 'Range' of object '_Global' failed."
I thought maybe indexA needed to be further defined so I tried

For indexA As Integer = 1 to 10
Range(cells(indexA, indexA +3)).Select
...
Next indexA

Now it won't accept the first line "As Integer" and says "Expected: =" even though there is one.

How can I implement the counter "indexA" in my code, and why isn't it accepting the datatype argument?

 

[farmerscott]

TylrA,

Welcome to the forum.

It is a little unclear from your code if you want to select a single cell or a range.

If you want a single cell use

Cells(row,column).select

or if you want a range using the cells method-

Range(cells(row,column),cells(row,column)).select

Hope that helps,

FarmerScott

 

[sericom]

What cell/s should be selected on the first loop?
You need to specify the variable type on it's own line

Dim indexA As Integer
For indexA = 1 to 10

 

[TylrA]

Thanks! That answers part of my question.

To farmerscott,
Just a cell. I guess it would be better put like this then:

For indexA = 1 to 10
Cells(indexA, indexA + 3).Select
...
Next indexA

I still seem to have an error in the syntax because the debugger stops on line 2. How should I write that?

 

[TylrA]

It works, thanks!

 

[farmerscott]

Glad that you got it working.

Remember you don't need to use "select" to do something to a cell or range.