You could try code like this.
By the way why do you want to do this, you don't actually need to select/activate cells/ranges to work with them.Dim rng As Range Dim c As Range Set rng = Worksheets("Sheet1").Range("A1:A450") For Each c In rng.Cells c.Activate Next c




Reply With Quote