"Henrietta Horne" wrote in message
...
On Thu, 13 Jan 2011 09:53:10 -0600, "Clif McIrvin"
wrote:

<...
Are you familiar with the formula auditing tools? I built a simple
worksheet with Ron's formula, then stepped through it with the
"Evaluate
Formula" tool so I could understand what makes it work. Pretty neat!

No, I'm not. I'll add it to my todo list.

That's the problem. There are so many interesting features to learn
and they are such a temptation for procrastinating what I really nood
to do, which is get the project done. ;-)


Been there. Almost every day, in fact <g.

Don't be afraid to slap together some ugly code that works - how
important it is that you ever get back to refine it depends on your
circumstances. If that macro is going out to 500 users in the
organization, then you'd better find the time to make it pretty
bullet-proof and self explanatory. If you're the only one that's ever
going to use it, it can stay that way forever - at least until the need
comes up to modify the rules, at which time you can apply the knowledge
you've gained in the interim to improve it. At least, that's the way I
approach it here <grin.


--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)