Copying a named range with a changing cell reference

  • Thread starter Thread starter jwilkes
  • Start date Start date
J

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

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

Regards,

Per
 
Back
Top