Run-time error 91 keeps popping up when i try manually amending/typing other columns which are not included in the macro code. How do I automatically bypass error-91 when this occurs rather than selecting end each time. My code is:
Please Login or Register to view this content.
Last edited by chris1089; 12-20-2021 at 09:59 AM.
Go back to other thread here
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Hi Chris,
Looking at the code - the change event has not been restricted to only fire on specific cells, i have modified the second part of the code to do this, see below:
Hope this helpsPlease Login or Register to view this content.
Just on another note, don't try to "bypass" or "ignore" these errors, they mean something is broken, and it needs to be fixed if you wish for the sheet to continue functioning.Originally Posted by chris1089
Run-time error 91 keeps popping up when i try manually amending/typing other columns which are not included in the macro code. How do I automatically bypass error-91 when this occurs rather than selecting end each time. My code is:
Please Login or Register to view this content.
Perfect thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks