Create a dynamic range reference

One of the most common issues that arise in Excel is that a range that contains data will eventually expand as more data are added or even contract as data are removed. If we have a formula, or an Excel functionality (such as Data Validation or a PivotTable), or a chart, that refers to such a dynamic range, we must adjust the formula whenever the size of the range changes. That is obviously impractical and is a major source of problems and errors in an Excel model.

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0101_Create_a_self_adjusting_range.shtml

Tushar Mehta

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>