Re: Scripting in Excel -> search different words in column and color them
Re: Scripting in Excel -> search different words in column and color them
- Subject: Re: Scripting in Excel -> search different words in column and color them
- From: Kai Edwards <email@hidden>
- Date: Sun, 27 Oct 2002 15:12:07 +0000
on Thu, 24 Oct 2002 23:39:29 +1300, David Wignall <email@hidden> wrote:
>
on 24/10/2002 11:16 PM, Kai Edwards at email@hidden wrote:
>
>
> on Thu, 24 Oct 2002 17:09:48 +1300, David Wignall <email@hidden> wrote:
>
>
>> One very small point, Bjorn: are you looking for the word "FALSE" or the
>
>> result FALSE or both, in which case this...
>
>>
>
>>> repeat with findVal in {"missing", "FALSE", "empty"}
>
>>
>
>> could become
>
>>
>
>> repeat with findVal in {"missing", "FALSE", "empty", false}
>
>
>
> OMM, setting findVal to "FALSE" is enough to pick up the word "FALSE" *and*
>
> the result FALSE - as long as the parameter 'LookIn' is specified as
>
> 'xlValues' (as it was in my suggestion). Are you really getting different
>
> results from this?
>
>
Um, no. Sorry about that. No excuses, really...
Thanks for that, David. (Just checking to make sure I hadn't missed any
changes of behaviour between different versions.) The point you were making
is, of course, relevant when comparing values in AS - so it was well worth
raising. :-)
Obviously, since my original suggestion performed a find in Excel, the
comparison criteria differed slightly.
Best wishes.
Kai
--
email@hidden
email@hidden
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.