Home > IT Blogs > Beyond Excel: VBA and Database Manipulation/

Beyond Excel: VBA and Database Manipulation:

February, 2011

1
February 24, 2011  6:53 PM

Solving Dynamic Ranges with Tables/ListObjects



Posted by: Craig Hatmaker
database, development, dynamic ranges, excel, ListObjects, Microsoft Excel, ms query, odbc, sql, Tables, tutorial, vba

Dynamic named ranges have been a subject of interest on Excel boards for sometime.  Lots of people want to know what's the best way to create a named range that expands (or shrinks) according to the data entered, and can be used in formulas like VLOOKUP without change.  For some background...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1