Copying a named range with a changing cell reference

[jwilkes]

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

 

[Per Jessen]

Hi

If you only need the values to be copied, you can use "Paste Special" and
select values to be pasted.

Regards,

Per