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