Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Discussion (Misc queries) | |||
Sort Macro | New Users to Excel |