It happens that Matthew Dyer formulated :
I tried all three examples and i still keep getting the type mismatch
error...

Matthew,
I tested all 3 examples with actual data across 2 workbooks and they
worked for me.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc