You could replace you two lines of code with this.
Range("J2").AutoFill Destination:=Range("J2", Cells(Rows.Count, 1).End(xlUp).Offset(0, 9)), Type:=xlFillDefault
Cheers!
You could replace you two lines of code with this.
Range("J2").AutoFill Destination:=Range("J2", Cells(Rows.Count, 1).End(xlUp).Offset(0, 9)), Type:=xlFillDefault
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks