Help regarding copying data to excel

actually the file name is "new orddrs.xlsx" and the sheet name is "Orders Data"

the code stop on the word xlUP

Any help regarding this issue is really appreciated

I will ask this again: What is the error message?

When execution stops, it stops on a complete line of code. What do you mean "the code stop on the word xlUP"?

When the code stops, press CTRL-G to open the Immediate window. In that window type

print xlSheet.Rows.Count

and then tell us what the response is. If is a positive integer, then I don't know why this line of code is giving you an error. If it gives an error, please provide the error information.

I can't reproduce the error without your file although I set up a small example where the exact same line of code works properly.