Change a static range by a dynamic one

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Change a static range by a dynamic one

FAQ

Thread Tools

Display Modes

07-28-2017, 03:53 PM

NoSparks

Windows 7 64bit Change a static range by a dynamic one

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change the definition of range name	cspitser	Excel	2	03-29-2017 01:30 PM
Copy dynamic range between workbooks	elieprolb	Excel Programming	4	02-06-2017 12:40 AM
Workarounds for the find "dynamic" range bug in VBA?	Robert K S	Word VBA	2	11-07-2016 01:00 PM
Dynamic font color change	Critcheeees	PowerPoint	2	01-27-2015 02:45 AM
Multiple Dynamic Worksheets Consolidated into One Static Worksheet	mars1886	Excel Programming	3	02-09-2014 12:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 PM.