Insert this line as 1st line of your macro:
Worksheets("sort").Select
Regards,
Stefi


€žcurtc.€� ezt Ã*rta:

I need to add a line to the macro, so that it only works on a sheet named
"sort". This is so if the short cut to run the macro is run by accident (when
another sheet tab is the current worksheet) it only affects the data on the
"sort" worksheet. How do you identify which sheet of a workbook a macro is
assigned to run in...and that sheet only, even if you are working in another
worksheet (same workbook though)?