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