I had an occasion to create about 25 dynamic named ranges. A tedious process, that. So I cooked up some code. All the ranges needed to start in row 2 and extend down as far as there is data. There wouldn’t be any blanks, so I didn’t worry about it. In this [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/04/16/creating-dynamic-names-in-vba/
Posted
Apr 16 2010, 03:28 PM
by
Daily Dose of Excel