| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a Name's Contents
Garry,
The macro below runs without error: Dim rngSource As Range, rngTarget As Range Set rngSource = Workbooks("Book1.xlsb").Sheets("Sheet1").Range("Na me1") Set rngTarget = Workbooks("Book2.xlsb").Sheets("Sheet1").Range("A1 ") rngTarget.Resize(rngSource.Rows.Count, 1).Value = rngSource However, after the macro runs, the contents of A1:A3 in Book2.xlsb is empty. kittronald |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modifying a Defined Name's Contents | Excel Programming | |||
| Put Name's Refer's to: field in cell | Excel Programming | |||
| Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents | Excel Programming | |||
| Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents | Excel Programming | |||
| How to Print Name's list and Names Range? | Excel Worksheet Functions | |||
Threaded Mode
