Macro to select Last Row and sort it to above data

[kosherboy]

Hi all!
I made the part of the code that is causing issues red.
I am trying to select the last row and sort it by column C into the data above.
Looking forward to any responses

Please Login or Register  to view this content.

[AB33]

Remove the select

Please Login or Register  to view this content.

[kosherboy]

Hi and thank you for the response.
I tried that before but it didn't work

[AB33]

Did you get an error? If so, in which line?
The sort bit of code appears to be recorded macro.

[kosherboy]

The line that read "With ws.Range(LR)" got highlighted.
And yes, the sorting was recorded.

[AB33]

Okay! Where is LR in your data?

[kosherboy]

The last row in column A

[AB33]

Yes, but that is not the range.

Please Login or Register  to view this content.

[kosherboy]

AB33, now my code is working flawlessly

Thank you.