Apologies for not reading it more carefully Tom, I hadn't picked up on that.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Tom Ogilvy" wrote in message
...
Ken,
he wants to make a onetime selection of the sub to be called, then use it in
his loop.
Thus the recommendation to use application.Run
although I suspect the overhead of including the case construct in the loop
with the advantage of using Call (as you suggest) would significantly
overcome any advantage gained by the reduction to one case statement but
incurring the overhead of using application.run 11000 times.
--
Regards,
Tom Ogilvy
<snip
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004