I'm trying to use a VBA to expand(horizontally and vertically) a data validation table which serves as a lookup for my Recs Table. The VBA seem to work alright however its using the column heading(highlighted in the attached) as the name, instead I want the row head which is in Column A(ExamCenter) be the range name. Also I want the range to include the range name/row head.(screenshot in the attached). Any help to tweak the macro will be much appreciated. Thanks
Bookmarks