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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a Named Range with changing cell references 1
Recalc of SUM() that refers to a cell across a range of worksheets 4
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
worksheet references 3
Array with many cells from a row but not in order or together 11
Code to name numerous ranges 11

Back
Top