VBA amendment to change range selection

Hi Guys,

I have managed to piece together this code to retrieve data from a closed workbook and it's working pretty well so far

Please Login or Register  to view this content.

What I would like to do however and am struggling with is to change the range selection to only select the cells with data effectively to mimic this crudely recorded code

Please Login or Register  to view this content.

And then to paste this selected data into the destination sheet2 (A4).

To clarify, the data will always be in columns A-U but the number of rows will change.

Any help would be very much appreciated!

Thanks in advanced.

Spoonman