LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Sort A-Z not working but did in 2000 JohnHamer1977 Excel Discussion (Misc queries) 0 August 29th 06 03:12 AM
Macros shortcuts not working from 2003 to 2000 WSW Excel Worksheet Functions 0 May 8th 06 04:26 PM
Charts not updating in 2002,2003 but working in 2000 Richard Bond[_2_] Excel Programming 4 August 28th 05 04:20 AM
Excel VB 2000 not working in 2003 A Lost Soul New Users to Excel 2 March 22nd 05 01:21 PM
XL 2003 macro not working in XL 2000 Steve R[_2_] Excel Programming 2 April 7th 04 04:45 PM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"