Copy Name Range in another spreadsheet

**pal_slg** · 12-03-2011, 11:01 AM

Hi

I have several name ranges in a sheet but somehow the file is not responding properly and now I want to create a new file copying all data I have in the old sheet to the new one. But the problem i am facing is to copy the name ranges that I have created. There are more than hundred name ranges and I do not know how to copy them in the new file. Select Copy Paste is not working here. Can anybody help?

Thanks
Pal

**dilipandey** · 12-07-2011, 09:16 AM

Hi Pal,

Right click on the worksheet and choose copy from there, this will copy the data along with the range names.

Cheers

Regards,
DILIPandey

**pal_slg** · 12-15-2011, 01:07 PM

Hi Dilip,

Thank you for your reply. Sorry I did not see your post earlier. I think there was some problem with the site.
I tried your method and it was amazing. It saved a lot of additional effort. Thank you so much!!
Pal