(Solved) – How to avoid using Select in Excel VBA

  • by
(solved)-–-how-to-avoid-using-select-in-excel-vba

I’ve heard much about the understandable abhorrence of using .Select in Excel VBA, but am unsure of how to avoid using it. I am finding that my code would be more re-usable if I were able to use variables instead of Select functions. However, I am not sure how to refer to things (like the ActiveCell etc.) if not using Select.

I have found this article on ranges and this example on the benefits of not using select but can’t find anything on how?

Leave a Reply

Your email address will not be published. Required fields are marked *