I think this may be happening because you have jumped out of the loop - you cannot simply jump back in again.
So you need to trap and handle the error whilst remaining inside the loop - for instance using the iserror function.
I am always wary of creating infinite loops when playing with the loop counter, so watch out for that !
PS Is there meant to be a space in ElseIF Selection . . . ?
Last edited by MartinGM; 12-18-2023 at 01:05 PM.
|