|
sort issue
Here is my code:
Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
sort issue
Are you all using the same version of excel?
DataOption1:=xlSortNormal was added in xl2002. If your users use earlier versions, remove that parm. Shawn wrote: Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn -- Dave Peterson |
sort issue
Hi Shawn,
If your user has abn earlier version (xl2k?) then: DataOption1:=xlSortNormal would cause a problem as this argument would not be recognised. When writing an application, it is important to develop using oldest version of Excel likely to be encountered. --- Regards, Norman "Shawn" wrote in message ... Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
sort issue
How should I write that code?
There error is: "Compile error, variable not defined" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, If your user has abn earlier version (xl2k?) then: DataOption1:=xlSortNormal would cause a problem as this argument would not be recognised. When writing an application, it is important to develop using oldest version of Excel likely to be encountered. --- Regards, Norman "Shawn" wrote in message ... Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
sort issue
If I remove: , _
DataOption1:=xlSortNormal it will work in any version? -- Thanks Shawn "Dave Peterson" wrote: Are you all using the same version of excel? DataOption1:=xlSortNormal was added in xl2002. If your users use earlier versions, remove that parm. Shawn wrote: Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn -- Dave Peterson |
sort issue
Hi Shawn,
As suggested By Dave in his adjacent post, delete the contentious parameter: Selection.Sort Key1:=Range("G7"), _ Order1:=xlDescending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom --- Regards, Norman "Shawn" wrote in message ... How should I write that code? There error is: "Compile error, variable not defined" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, If your user has abn earlier version (xl2k?) then: DataOption1:=xlSortNormal would cause a problem as this argument would not be recognised. When writing an application, it is important to develop using oldest version of Excel likely to be encountered. --- Regards, Norman "Shawn" wrote in message ... Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
sort issue
Is that causing, "compile error, variable not defined?"
-- Thanks Shawn "Norman Jones" wrote: Hi Shawn, As suggested By Dave in his adjacent post, delete the contentious parameter: Selection.Sort Key1:=Range("G7"), _ Order1:=xlDescending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom --- Regards, Norman "Shawn" wrote in message ... How should I write that code? There error is: "Compile error, variable not defined" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, If your user has abn earlier version (xl2k?) then: DataOption1:=xlSortNormal would cause a problem as this argument would not be recognised. When writing an application, it is important to develop using oldest version of Excel likely to be encountered. --- Regards, Norman "Shawn" wrote in message ... Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
sort issue
Hi Shawn,
Yes - in versions prior to xl2002. --- Regards, Norman "Shawn" wrote in message ... Is that causing, "compile error, variable not defined?" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, As suggested By Dave in his adjacent post, delete the contentious parameter: Selection.Sort Key1:=Range("G7"), _ Order1:=xlDescending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom --- Regards, Norman "Shawn" wrote in message ... How should I write that code? There error is: "Compile error, variable not defined" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, If your user has abn earlier version (xl2k?) then: DataOption1:=xlSortNormal would cause a problem as this argument would not be recognised. When writing an application, it is important to develop using oldest version of Excel likely to be encountered. --- Regards, Norman "Shawn" wrote in message ... Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
sort issue
That's the default for xl2002+, so it should.
Shawn wrote: If I remove: , _ DataOption1:=xlSortNormal it will work in any version? -- Thanks Shawn "Dave Peterson" wrote: Are you all using the same version of excel? DataOption1:=xlSortNormal was added in xl2002. If your users use earlier versions, remove that parm. Shawn wrote: Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn -- Dave Peterson -- Dave Peterson |
sort issue
I have a variation on this problem. I'm using Excel 2002 sp3. The VBA code
is quite simple. Application.Goto Reference:=SubAcctDB ' where this variable is set to a defined named range Selection.Sort Key1:=Range("BA14"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal The result is the following: Compile Error: Mehtod or data member not found. I'm totally lost since I have done these kinds of sorts 50 times. Can you help me with this? Thanks! Steve -- sbw "Norman Jones" wrote: Hi Shawn, Yes - in versions prior to xl2002. --- Regards, Norman "Shawn" wrote in message ... Is that causing, "compile error, variable not defined?" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, As suggested By Dave in his adjacent post, delete the contentious parameter: Selection.Sort Key1:=Range("G7"), _ Order1:=xlDescending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom --- Regards, Norman "Shawn" wrote in message ... How should I write that code? There error is: "Compile error, variable not defined" -- Thanks Shawn "Norman Jones" wrote: Hi Shawn, If your user has abn earlier version (xl2k?) then: DataOption1:=xlSortNormal would cause a problem as this argument would not be recognised. When writing an application, it is important to develop using oldest version of Excel likely to be encountered. --- Regards, Norman "Shawn" wrote in message ... Here is my code: Range("A6", Range("G65536").End(xlUp)).Select Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A6").Select It works fine on my machine. However, when I e-mail this file to other users, they get an error and the Selection code is highlighted??? -- Thanks Shawn |
| All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com