View Single Post
 
Old 12-18-2023, 03:48 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 108
MartinGM is on a distinguished road
Default

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.
Reply With Quote