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................

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

"(E-Mail Removed)" 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................
>