Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code works - need to save | Excel Discussion (Misc queries) | |||
VBA Code Help - Moved from an older topic | Excel Discussion (Misc queries) | |||
Code works within VBE but not from Excel | Excel Programming | |||
VB code needed for running newer excel version macros in older excel versions | Excel Programming | |||
Code for runnning macros created in XP in older excel versions | Excel Programming |