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)?

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)?

I think it would be better to qualify your ranges.

Instead of

range("A1:B99").sort key1:=range("a1"), ...

use

with worksheets("Sort")
.range("a1:B99").sort key1:=.range("A1"), ....
end with

The dots in front of those .Range()'s means that they belong to the object in
the previous with. In this case, that's the Sort worksheet.

If you have trouble adjusting your code, post what you have and I'm sure you'll
get help.

curtc. wrote:

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)?

--

Dave Peterson