I tested that line of code
everything is ok but the error will appear if there are no data in Column H![]()
Range("A1:D1").AutoFill Destination:=Range("A1:D" & Cells(Rows.Count, "H").End(xlUp).Row)
I tested that line of code
everything is ok but the error will appear if there are no data in Column H![]()
Range("A1:D1").AutoFill Destination:=Range("A1:D" & Cells(Rows.Count, "H").End(xlUp).Row)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks