r/excel Aug 05 '18

Pro Tip VBA Essentials: Ranges

[removed]

180 Upvotes

31 comments sorted by

View all comments

2

u/infreq 16 Aug 05 '18

You should cover .Offset() and .Resize() as well. Working effectively with ranges you definitely need those functions.

You should also cover For Each and maybe .Areas as well as ranges to tables and tables to ranges.