PasteSpecial Paste:=xlPasteAll doesn't paste named ranges

[dfarland]

I am trying to use the PasteSpecial method to copy a range along with any named ranges. The named ranges do not paste, any help out there?

 

[SkipVought]

Hi,

Excel doesn't copy range names, just values and formats.

If excel did copy names as well, and your range name were Fred, then what should the name of the new range be since you could not have two Freds on the same sheet?

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Zathras]

Not sure it's possible. Range names need to be unique, and they are sheet-specific.

Can you provide more details on what it is that you are trying to do?