stepping thru XL files

Hello sydmil,

To make your posts easier to read and copy, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Sincerely,
Leith Ross

Hello sydmil,

This macro should get you going. This is set to copy the range "A2:C35" from "Sheet1" of the source workbook, to "Ax" on "Sheet1" of the workbook the macro is in. "Ax" starts at cell "A2" and goes down.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith,

thank you for your response and sorry for taking so long to get back.

I am getting the following error on this line:
LastRow = .Cells(Rows.Count, .Column).End(xlUp).Row


"Error 1004: Application-defiend or object defined error."

Any idea what is causing that ?

Thanks!