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
Attachment 707
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
