Find last row and drag down

Hi,

Im trying to get this to work. Im using code to count last row in A column starting from A" and then based on that number drag down to matching row in the active sheet (XML2).

So if the number of rows in A is 250 then it should drag down A2:X250.

I have enclosed my code for reference.

Please Login or Register  to view this content.

Any ideas?

Kind regards,
VBAtor

Hi again!

I managed to solve it with the following code:

Please Login or Register  to view this content.