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: Thu, 24 Oct 2002 10:16:11 +0000
on Thu, 24 Oct 2002 17:09:48 +1300, David Wignall <email@hidden> wrote:
>
> on Wed, 23 Oct 2002 16:12:35 +0200, Bjorn Van Blanckenberg <email@hidden>
>
> wrote:
>
>
>
>> I want to search in 5 columns the word "missing" or "FALSE" or "empty" and
>
>> if it is found color it red and set the font to bold
>
>>
>
>> Could somebody point me in the right direction
>
>
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?
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.