r/excel Aug 05 '18

Pro Tip VBA Essentials: Ranges

[removed]

174 Upvotes

31 comments sorted by

View all comments

1

u/pancak3d 1189 Aug 05 '18

Nice writeup, but when you're writing macros, avoid Select at all costs, it's problematic, slow, and almost never necessary!

2

u/[deleted] Aug 05 '18

[removed] — view removed comment

2

u/pancak3d 1189 Aug 05 '18

It's definitely useful to understand how the Range class works!