hi all,
having some trouble with below code.
Trying to copy ranges B:G & I:T (exclude column H) to last row and paste to new sheet.
The code works but when it paste's it includes column H data?
![]()
Dim LastRow As Long LastRow = Sheets("Data").Range("B" & Rows.Count).End(xlUp).Row Sheets("Data").Range("B10:G" & LastRow, "J10:T" & LastRow).Copy Sheets("Load").Range("B10:S" & LastRow).PasteSpecial xlPasteValues
Bookmarks