vba

(Solved) How to avoid using Select in Excel VBA

by

Some examples of how to avoid select Use Dim‘d variables Dim rng as Range Set the variable to the required range. There are many ways to refer to a single-cell range: Set rng = Range(“A1”) Set rng = Cells(1, 1) Set rng = Range(“NamedRange”) Or a multi-cell range: Set rng = Range(“A1:B10”) Set rng = … Read more