[RESOLVED] Switching worksheets

[AlexanderBB]

Hi,
Becase of the way my project has expanded, I want to switch worksheets
in the middle of a For-Next Loop.

The trigger is when the Loop index reaches 13921.

However the line,

If Indx > 13921 Then With Worksheets("Sheet2")

invokes

Compile error: End If without block If

Can this be circumvented, or should I try a different approach?

Thanks, ABB

[westconn1]

is this a for each loop or for var =

show the code for the loop and leading into the loop

[anhn]

That should be:

If Indx > 13921 Then 
    With Worksheets("Sheet2")
        ...
    End With
End If

[AlexanderBB]

Thanks very much Anhn and Westconn. It was a For-Next. I tried that Anhn but I wanted the same
'with' code to execute regardless of Indx, but Indx to change With to point at another sheet at 13921.

I ended up using a variable then
If Indx > 13921 Then SheetIWant = "Sheet2"
myvalue = Worksheets(SheetIWant).Cells(row, col)

Seems to work...

Regards, ABB

[Siddharth Rout]

If Indx > 13921 Then myvalue = Worksheets("Sheet2").Cells(row, col)

[AlexanderBB]

Thanks Koolsid, I should have known that.

Regards, ABB