I have a number of ranges on a worksheet whose names differ by two digits (i.e., a two digit year). Examples are '_17_data', '_18_data', '_19_data', representing different ranges for data corresponding for years 2017, 2018 and 2019.
Is there a way to construct the range name in VBA from a variable (yr); i.e., something like rng = "_" & yr & "_data"?
Thanks.
Bookmarks