Hi Cindy,

cindy wrote:
Thanks Jake

You're welcome - glad to help out!

It works! Also, thanks for the tip on declaring
variables. I thought when you separated by a comma on the
same line they would all be declared as that type.

No problem. That's a very common misconception, BTW.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]