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
