Thread
:
Change a static range by a dynamic one
View Single Post
07-28-2017, 03:53 PM
NoSparks
Windows 7 64bit
Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
Depending on how the data is loaded into columns A&B, I'd consider using an Excel table, then you could just refer directly to the table columns.
A page on table stuff...
https://www.thespreadsheetguru.com/b...t-excel-tables
NoSparks
View Public Profile
Find all posts by NoSparks