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