Copying a Named Range with changing cell references
 

..PasteSpecial Paste:=xlPasteValues would be my guess. That would not
transfer any formulas or formats from the source range or sheet.

" wrote:

I am writing a macro to copy a sheet from a workbook to a new
workbook, it has hiddden rows which i am not copying just values,
however, I also want to copy the named ranges to the new sheet, the
problem being the cell references change as I get rid of hidden rows
and columns. Is there any way to carry over a named range, having it
refering to values or cell content rather than actuall cell
references................