It probably fails because it goes to the last row and the tries to select the row after the last row, which obviously doesn't exist. You can try this altered code.
Sub export()
Sheets("Sheet1").Range("Q2:AK2").Copy
Workbooks.Open ("C:\Users\christians\Desktop\excel\test.xlsx")
Sheets("Test").Activate
Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Select '1st empty row in col A
ActiveCell.PasteSpecial xlPasteAll
Application.CutCopyMode = False
End Sub
edit: also, please use code tags around your code to comply with forum rules.
edit2: I love how you have a folder for Christian users. :P
Bookmarks