Hi
I am using
to add data to last row of column AB.Worksheets("Sheet1").Range("A1:A7").Copy Worksheets("Sheet2").Cells(Rows.Count, 28).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValuesAndNumberFormats
The data in columns AB to AH have a border as seen here.
The question is what to add to above code to reset the block border so that it includes the pasted data.
Note that inserting a row is NOT an option as that would disrupt adjacent data.
Thanks
Bookmarks