Here is an example of what I was talking about. I was bored and asked "Chatty" a non-specific question. It helped wrote a PS script a few months back whose primary purpose is a FE Updater. I kept adding features and in the process, shared a few things about the application; the Workload...
An interesting read on Function behavior. It doesnt really "solve" the problem or answer you question, but you may learn something about functions you may or may not have known...
Every Function in VBA Returns a Value https://share.google/docQnUy2ZI7Eo9o4q
Very impressive! It took me a second to understand what was going on (RowNumber) and then even longer to adapt it to my situation. Once I got it sorted, it works great and is significantly faster.
I really like this method over my original process; more precise and not having to fuss with...