LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default VBA Excel 2000 issue

My code and program were written in Excel 2003 and
everything works fine. My Excel 2000 users report a run
time error 1004 when they exceute my code. When I have
them push the "Debug" button they are taken to my Sort
History macro where the "Selection..." section is
highlighted, code attached below. Since Excel 2003 does
not generate the error can you help me ID the error and a
corrective action. Thanks.

Sub SortHistory()
Sheets("Concern History").Select
Range("A2:AK25000").Select

'Debugging brings me to this point to DEBUG

Selection.Sort Key1:=Range("A2"),
Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("A2").Select

End Sub

 
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
Rounding issue in Excel 2000 GregNga Excel Discussion (Misc queries) 6 August 17th 09 11:19 PM
Excel 2000 Font Format Issue Tess Excel Discussion (Misc queries) 6 August 17th 09 10:41 PM
Excel 2000 Issue Scott Nash Setting up and Configuration of Excel 4 October 19th 06 08:11 PM
Create macro to download access 2000 table to excel 2000 spreadsheet Tushar[_2_] Excel Programming 3 October 21st 04 02:44 PM
Code-signing certificate problems in Excel 2000 with Windows 2000 Aaron Queenan Excel Programming 0 May 6th 04 11:35 AM


All times are GMT +1. The time now is 07:27 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"