vba

(Solved) How to avoid using Select in Excel VBA

by

[ad_1] 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