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: 30
Default Any way to save VBA code so it works with older Excel revisions?

The programming below was recorded and modified in Excel 2003, it fails on
Excel 2000. Is there a way to save the file or convert it to make it work in
Excel 2000 without having to sit down and debug all of what is
non-compatible? I doubt there is, but thought I would see if there was a
quick and easy way. Thanks.

Range("A16:P500").Select
Selection.Copy

Range("S16").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats,
Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

Application.CutCopyMode = False
Selection.Sort Key1:=Range("AG17"), Order1:=xlAscending, Key2:=Range( _
"af17"), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1,
MatchCase _
:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, _
DataOption2:=xlSortNormal
 
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
code works - need to save Ted Roche Excel Discussion (Misc queries) 1 January 7th 09 06:08 PM
VBA Code Help - Moved from an older topic jlclyde Excel Discussion (Misc queries) 3 January 10th 08 04:26 PM
Code works within VBE but not from Excel SpaceCamel Excel Programming 3 November 15th 04 11:54 PM
VB code needed for running newer excel version macros in older excel versions Tom Excel Programming 6 October 16th 03 03:11 AM
Code for runnning macros created in XP in older excel versions Tom Excel Programming 1 October 15th 03 02:41 PM


All times are GMT +1. The time now is 10:25 PM.

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

About Us

"It's about Microsoft Excel"