| 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 | |||
Hybrid Mode
