Macro to Open File/s and copy data won't work

I have written code to open data and select a file/s and then to copy the data from sheet1 to sheet imported data

When running the macro, I get run time error-Application defined or object defined error

The following part of the code is highlighted

Please Login or Register  to view this content.

See full code below

Please Login or Register  to view this content.

I have attached my destination workbook containing the macro "Import Payment Data.xls" as well as my source workbook

It would be appreciated if someone could assist me

Version difference of Rows.Count
Change to

Please Login or Register  to view this content.

Thanks for pointing out where the problem lay


have tested-code now works perfectly