J
John
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).Paste
I appreciate your help, -John
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).Paste
I appreciate your help, -John