Create a Macro to perform a custom sort on varying number of rows

Hi

I have a macro that I want to use to perform a custom sort on 4 columns. The number of rows varies each time the sort is performed. How can I amend the recorded code so that it will work regardless of the number of rows in the worksheet. Attached is a screenshot of my macro code.

Please post the actual code rather than a screenshot, you won't get as much help if people need to type out your code from a picture! Use code tags (The hash button on the reply toolbar) too.

Anyway, I'd sggest adding to the top of your code:

dim last_row
last_row = Sheets("Breaches").Range("A" & rows.count).end(xlup).row

and then changing anything that looks like:

Key:=Range("C2:C204")

to

Range("C2:C" & last_row)

Thanks for that and also for the advice on sending code itself rather than a screenshot. Worked perfectly.