Re: Excel 2004 Scripting Block
Re: Excel 2004 Scripting Block
- Subject: Re: Excel 2004 Scripting Block
- From: "Shane Stanley" <email@hidden>
- Date: Fri, 29 Oct 2004 08:56:24 +1000
On Thu, 28 Oct 2004 12:01:03 -0700, Paul Berkowitz wrote:
>On 10/28/04 11:29 AM, "Paul Berkowitz" <email@hidden> wrote:
>
>> OK. Now, looking for the first cell of the used range whose value is
>> "6001-014" crashes Excel here. This is a serious bug - I'll report it.
>'whose'
>> clauses don't seem to work on value of cells, without crashing.
>
>But it doesn't matter, since there's a much faster way even than whose
>clauses, using Excel's own 'find' command.
Although it does matter if you want to use an AppleScript containment
operator like "begins with". In that case, it's usually going to be be
much quicker to get the value of the whole range, and let AS loop through
the results, rather than get individual values from Excel one at a time.
--
Shane Stanley <email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden