View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
curtc.[_2_] curtc.[_2_] is offline
external usenet poster
 
Posts: 3
Default Sorting Columns Independently Followup From 3/13

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