Beyond Excel: VBA and Database Manipulation:

February, 2011

February 24, 2011  6:53 PM

Solving Dynamic Ranges with Tables/ListObjects

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: