By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

VBA Error in Excel under OS X

P: 1
Below is error when running a sort on a Excel sheet downloaded from the web for debt consolidation. I suspect it maybe because created on MS but am trying to run in Excel on a Mac OSX. Am I wasting my time or can this be fixed? Appreciate feedback.


Sub sortit()
'
' sortit Macro
'

'
Range("B8:G28").Select
Selection.sort Key1:=Range("G9"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("B9").Select
End Sub
Jan 24 '08 #1
Share this Question
Share on Google+
2 Replies


P: 58
Try removing...
", _DataOption1:=xlSortNormal"



Below is error when running a sort on a Excel sheet downloaded from the web for debt consolidation. I suspect it maybe because created on MS but am trying to run in Excel on a Mac OSX. Am I wasting my time or can this be fixed? Appreciate feedback.


Sub sortit()
' sortit Macro
Range("B8:G28").Select
Selection.sort Key1:=Range("G9"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("B9").Select
End Sub
Jan 27 '08 #2

Expert 5K+
P: 8,434
Can you tell us the details of the error?
Jan 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.