Hi

Most of time we need to create dynamic name ranges to use them in charts n all , i have created an add-ins, that will do this job for you,
see the attached add ins here
CreateDynamicNameRanges.xlam

when you will add this add-ins .. it will show a button on Ribbon, just select your Range and Press that button.and follow the instruction

Regards
Rajan