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