Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.

Want to name a range in Microsoft Excel? This post shows how to edit or create Named Ranges in Excel using four methods.