Help regarding copying data to excel

[Asaad Fawzy]

Dear All,
I have the below macro to move the data to excel and it working so good on 2007 and once I moved to 2013 it can't work and stop on the line below
rCount = xlSheet.Range("A" & xlSheet.Rows.Count).End(xlUp).Row
could you please help me to solve

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

[6StringJazzer]

What is the error message?

What is the value of xlSheet.Rows.Count when it stops? If that value causes an error, what are the values of xlSheet.Parent.Name and xlSheet.Name?

[Asaad Fawzy]

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

the code stop on the word xlUP

[Asaad Fawzy]

Any help regarding this issue is really appreciated

[6StringJazzer]

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.