Thanks so much for taking the time to help me. I really appreciate it!

David F. Cox Wrote:
I do not know if there is a better answer than using the sumproduct
function. I would have to play with your spreadsheet to find out where,
if
anywhere, you are getting a performance hit. My boss and mentor
castigated
me for "optimising" some code saying "The computer is there to make
your
life easier, you are not there to make its life easier." Subsequent
experience has taught me that complicating simple tasks to make them
run
quicker is too often counter-productive, and sometimes surprisingly
unsuccessful.OTOH sometimes a bit of thought and a small tweak can
have
amazing results.
I would not have suggested that you rewrote your code if I did not
believe
that the end result would be more concise, understandable and
maintainable
code, as well as hopefully, being quicker.

good luck.

David F. Cox


--
chris46521
------------------------------------------------------------------------
chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909
View this thread: http://www.excelforum.com/showthread...hreadid=569999