Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort in 2003 not working in 2000
I've built a 26-column spreadsheet with macros to sort each column,
using XL 2003. When I loaded it onto my laptop which uses XL 2000, the macros fail. Here's one of the macros below. The error message says Run-time error '1004' .The debugger points out the section in in the middle starting with "Selection Sort". I'd really appreciate anyone telling me what I need to change, since I'm not a programmer and really need this sheet to work for my business ASAP. Sub NameSort() ' ' NameSort Macro ' Macro recorded 4/11/2006 by Owner ' ' Keyboard Shortcut: Ctrl+SHIFT+N ' Range("A1").Activate Cells.Select Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A1").Select ActiveWindow.SmallScroll Down:=1 ActiveWindow.SmallScroll ToRight:=1 Range("B2").Select End Sub Thanks in advance! - Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Sort A-Z not working but did in 2000 | Excel Discussion (Misc queries) | |||
Macros shortcuts not working from 2003 to 2000 | Excel Worksheet Functions | |||
Charts not updating in 2002,2003 but working in 2000 | Excel Programming | |||
Excel VB 2000 not working in 2003 | New Users to Excel | |||
XL 2003 macro not working in XL 2000 | Excel Programming |