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: David Wignall <email@hidden>
- Date: Thu, 24 Oct 2002 23:39:29 +1300
Hello Kai,
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...
--
Dave
_______________________________________________
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.