Macro sort
 

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

Macro sort
 

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
wrote:

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