"GS" wrote in message
...


*However*, it would be harder to update than changing a constant at
runtime,

You just lost me .... changing a constant at runtime??? Don't you mean
compile time?

My thinking was with a worksheet defined value, there would be no need
to open the VBE to change the parameter.


*AND* the defined name isn't as
portable as is the code!<g

Very true. The choice of solution depends greatly on developer
preference and the specific characteristics of the work environment,
doesn't it?!


--
Clif McIrvin

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