Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
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
 

Tags
error handler



Similar Threads
Thread Thread Starter Forum Replies Last Post
error handler: inserting building blocks when multiple cells in a table are selected creates error LSLSLS Word VBA 2 01-07-2022 05:46 AM
Error Handler If User Does Not Want to Overwrite File ChrisOK Excel Programming 4 04-03-2020 08:31 PM
Process Automation saurabhlotankar Excel Programming 10 06-03-2015 05:50 PM
How to Control Worksheet Event Handler in Module? tinfanide Excel Programming 2 10-19-2014 09:46 AM
'Infinite Loop' error with Infopath 2010 Debbie25 Misc 2 05-18-2011 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft