possible to copy cell with cell range name to worksheet??

[fredderf81]

Hi all, not sure if this is possible, i have been searching for info but have come up empty handed! i have have one worksheet with cells and named ranges. i have successfully entered the code to select the range and copy it to another worksheet. IE:

Please Login or Register  to view this content.

However...in the range, copyrng, that I am copying, there are cells with named ranges. the cells copy but the named ranges do not! I need those named ranges to copy to the new worksheet! Not sure if this is even possible but any help is appreciated.
Thanks

[ragulduy]

Please Login or Register  to view this content.

Use like:

Please Login or Register  to view this content.

[fredderf81]

phew!! thank you!!! that was way over my head but a great learning experience.