Re: excel
Re: excel
- Subject: Re: excel
- From: Stan Cleveland <email@hidden>
- Date: Wed, 17 Mar 2010 15:18:35 -0700
- Thread-topic: excel
On 3/17/10 9:27 AM, "Jan Bultereys" wrote:
> I am looking for the simple¹ code to sort ascending/descending starting from
> row 8 (sorting based on kolom A) in Excel leaving the header in row 7
> untouched.
Hi Jan,
Try one of these two commands as a starting point:
tell application "Microsoft Excel"
-- include header row, but don't sort it
sort range "A7:E99" key1 range "A:A" order1 sort ascending header header yes
-- alternate form to completely ignore the header row
sort range "A8:E99" key1 range "A:A" order1 sort ascending header header no
end tell
Change 'sort ascending' in the above commands to 'sort descending' to
reverse the order.
HTH,
Stan C.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
| References: | |
| | >excel (From: Jan Bultereys <email@hidden>) |