how to paste data using last row concept in VBA excel -
i have data in a2 d2 & in column e have data (which chaining day day - day 3000 or 4000 or 5000 on).
so have find last row of e column & paste data of a2 d2 till last row.
one way:
range("a2:d2").copy destination:=range("a3:d" & cells(rows.count, "e").end(xlup).row)
Comments
Post a Comment