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: has <email@hidden>
- Date: Fri, 25 Oct 2002 01:09:39 +0100
Paul Berkowitz wrote:
>
ASLG, pp. 256-7, but notice the catch described in the NOTES, requiring
>
'contents of' operator, or else evaluating the list item explicitly to a
>
variable. For that reason (i.e. forgetting about it), it's usually simpler
>
to use the 'Repeat With (loopVariable) From (startValue) To (stopValue)'
>
method.
I don't agree with this. I can't see using:
item i of foo
inherently being any simpler than using:
contents of foo
What's _hard_ is not getting tripped up by making blind assumptions about
how things work. This isn't helped by AS's reference type being such a
slippery, semi-transparent beast. Folks who try to learn everything by
trial and error are very likely to be bitten here, as it's very hard to
tell between a reference to a value and the value itself just by poking it
with a stick.
(I wish these sorts of things were made more self-evident in the language,
clarified by the editing tools, etc. but they's not. Sometimes you just
_have_ to knuckle down and RTFM if you want to know what you're doing.)
The other thing is remembering when a variable contains a reference. I find
appending 'Ref' to the names of those variables (as in 'fooRef') to be
extremely helpful.
has
--
http://www.barple.pwp.blueyonder.co.uk -- The Little Page of AppleScripts
_______________________________________________
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.