I recently posted about Creating Dynamic Names in VBA where created a bunch of names that would expand with the data provided. I created names that look like
=Sheet1!$C$2:INDEX(Sheet1!$C:$C,COUNTA(Sheet1!$A:$A))
I like Tushar’s idea so much that I deleted all my names and redid them using Offset (except column A of course). Tushar commented that I [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/05/04/creating-dynamic-named-ranges-in-vba-ii/
Posted
May 04 2010, 07:00 AM
by
Daily Dose of Excel