Macro sort

  • Thread starter Thread starter Excel user
  • Start date Start date
E

Excel user

I am having a hard time using macros to sort numbers. After I recorded the
sort colum that contained numbers and run macro on another excel sheet, it
doesn't work. What should be done to make it works?
Thanks
 
You probably have a hard-coded sheet reference like "Sheet1"

Change it to ActiveSheet


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 11:40:20 -0700, Excel user <Excel
 
Back
Top