Hello esteemed folks,
I have a spreadsheet that I have created a userform for that was working perfectly fine, however recently the users have started to experience a Runtime 9 - Subscript out of range error.
The code goes to the first line and isn't very helpful when put into debug mode. The line just states:
The range names haven't changed, there's no object in the ranges and the cells aren't merged or locked. I'm unsure what else to look for.
After speaking with users it appears this is happening whenever they lock their computer screen for some time, or start working in a different excel document.
I was wondering if these actions are interrupting the userform code somehow?
I have changed the reference from the sheet tab name to "Sheet1" but I'm not sure how else to fix the problem.
My issue also is that I have only ever been able to replicate the error once and everyone is using a copy of the same form that I am using.
Unfortunately I can't share the actual spreadsheet for GDPR reasons but was wondering if anyone has come across something similar or has any vague ideas on how to fix it?
Thanks
Adam
Bookmarks