Excel - Sorting: Selecting a range of columns sorting by ascend column

Scripting Forums AppleScript | Mac OS X
,
#1

Hey all trying to do the following. I have a range of columns A to M and I would like to do an ascending sort on column E. Tried searching and found the following sort code however not sure how to work the syntax to do what I want. Any help would be appreciated.


tell application "Microsoft Excel"
	select range "A:M"

	Sort Selection Key1 Range "R2C1" Order1 xlAscending Header xlGuess OrderCustom 1 Orientation xlTopToBottom
	end tell
#2

thanks for the direction:

here’s the code


tell application "Microsoft Excel"
	sort range "A:M" of column 1 key1 column 5 order1 sort ascending
end tell