| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named range row copy/paste problem
The last line of this code, the paste line, errors out. Both named ranges are
identically formated cols B-H on two different sheets, but the ranges have different numbers of rows. I'm trying to a copy a selected row from NamedRange1 to the second row of NamedRange2. Application.CutCopyMode = False Sheets("Sheet1").Range("NamedRange1").Rows(j).Copy Sheets("Sheet2").Select Sheets("Sheet2").Range("NamedRange2").Rows(2).Past e I appreciate your help, -John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy, Paste and Print Cells from a Named Range | Excel Programming | |||
| Copy & Paste Named Range Contents | Excel Programming | |||
| After Copy and Paste, Add to an Existing Named Range | Excel Programming | |||
| Copy and Paste 2 columns from a named range? | Excel Programming | |||
Threaded Mode
