Find last used cell, select, and copy

[Phippsy]

Hello all,

Looking for a macro that can find the last used cell in column A, then select the range of cells down to this cell over as far as column Y, and then copy the information.

I'm sure this would have been asked for before but I can't seem to find anything on it (probably searching incorrectly!)

Let me know if you need me clarify anything (New to this forum!)

Cheers in advance

Tony

 

[Joe4]

Something like this?

Dim lrow as Long
lrow = Cells(Rows.Count, "A").End(xlUp).Row
Range("A1:Y" & lrow).Copy

 

[Phippsy]

That is exactly what I was after!! Thank you very much, I owe you a pint

Cheers

Tony

 

[Joe4]

You are welcome!

A pint sounds great, though a little early in the morning for me here in the States!