Copy Name Range in another spreadsheet

[pal_slg]

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]

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]

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

[dilipandey]

You are welcome Pal.

Regards,
DILIPandey

< click on below 'star' if this helps >