| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying a named range with a changing cell reference
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................ |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a named range with a changing cell reference
Hi
If you only need the values to be copied, you can use "Paste Special" and select values to be pasted. Regards, Per skrev i en meddelelse ... 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................ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference first cell in a named range | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE | Excel Worksheet Functions | |||
| Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
Linear Mode
