lastRow1 = objWorksheet1.Cells(objWorksheet1.Rows.Count, “Site code (H3G Nominal)”).End(-4162).Row
objWorksheet1.Range(“Site code (H3G Nominal)2:Site code (H3G Nominal)” & lastRow1).Copy
lastRow2 = objWorksheet2.Cells(objWorksheet2.Rows.Count, “Architectural object number”).End(-4162).Row
objWorksheet2.Range( “Architectural object number” & FirstRow3 +1 ).PasteSpecial
New contributor
Nidhi Kowalli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.