J
John
I'm trying to copy a row from Sheet1 TableA and insert it as the first row in
Sheet2 TableB (pushing existing TableB rows down). The following coder seems
to only copy the first cell into all the row cells.
Worksheets("Sheet1").Range("TableA")(i).Copy
Worksheets(P("Sheet2").Range("TableB").Insert Shift:=xlDown
where TableX is a named 2-dim array range of all data rows & cols in the
table.
What must I change to copy the entire row?
Thx for your help, John
Sheet2 TableB (pushing existing TableB rows down). The following coder seems
to only copy the first cell into all the row cells.
Worksheets("Sheet1").Range("TableA")(i).Copy
Worksheets(P("Sheet2").Range("TableB").Insert Shift:=xlDown
where TableX is a named 2-dim array range of all data rows & cols in the
table.
What must I change to copy the entire row?
Thx for your help, John