Hi,

I have a worksheet which is always the same number of columns A:R but the number of rows varies.

I want to sort from row 2 to the row above the last row on the worksheet.

Which I can do using this -

Please Login or Register  to view this content.
This is another piece of code which I was wondering whether it could be adapted to do the above?

Please Login or Register  to view this content.
Many Thanks