I just want to copy the value of the below range
With ActiveSheet .Range("A1:Y" & .Cells(.Rows.Count, "F").End(xlDown).Row).Select Selection.Copy End With
and paste it to the other workbook, sheet name "XAMPP"in the last row of Column A.dim ads worksheet Set ads = wb.Worksheets("XAMPP")
I'm getting an error "Application-defined or object-defined error" in the highlighted line above.ads.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteAll
"wb" is declared as global.
Public wb As Workbook
Bookmarks