Okay, I figured out why it said Type Mismatch.

If a comment had "1 V. Term" and "1 Transfer Out" or ANY combination of
TWO or more different text strings, it would give me that error. But if
I had 2 of the same text strings in the same comment it wouldn't read
the second string to add it to the count.

Example:

________
1 V. Term:
Joe S

1 V. Term:
John S
________

This would bring back 1 as the value
when it should bring 2

________
1 V. Term:
Joe S

1 Transfer out:
John S
________

This would give me the error
when it should read 2


how do I correct the macro to make it give back the value I want?


--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=386198