The code to select the alphabetic entry looks OK, if a little repetitive.
Your print code could be a little slicker, for example:
And
Could just be:
And:
could be:
Similarly
could be:
The only thing I can think of is that an error occurs in another part of the code that resets some variable(s).
I appreciate that you had to take out the sensitive data but it's difficult to test stuff without representative information.
All the code is range specific so I'm not entirely sure if or how it works when you add entries into a range.
Sorry, I can't be more help at the moment.
Regards, TMS
Bookmarks