How can a already selected column be stored as a range object?

Asked Aug 11 '17 at 05:01

Active Aug 11 '17 at 06:34

Viewed 25 times

Getting a run time error: Object required. Need help with the syntax.

Dim rng1 As Range
Set rng1 = Range(Selection, Selection.End(xlDown)).Select

edited Jul 09 '18 at 19:34

Community

asked Aug 11 '17 at 05:01

user8379896

Just remove the .Select – Sixthsense Aug 11 '17 at 05:04
You're welcome :) – Sixthsense Aug 11 '17 at 05:09
1

But try avoid using `.Select`. Look at [this](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba). – Plagon Aug 11 '17 at 06:09

0 Answers0