John,

Think its best that you start a new thread in this MS vba forum:
http://social.msdn.microsoft.com/For...isvvba/threads

In your new post there, do mention your Excel version and ensure that
complete info is provided

MS has posted a msg that all xl newsgroups (like this one) will be closed in
end May 2010. As your query requires a vba solution, the forum above is
appropriate and you should be able to gather the expertise of vba responders
to get you going. The above forum is amongst those directed by MS for ng
posters, and is MS' way forward for queries wef Jun 2010. All the best to you
and farewell ..
---
Max
Singapore
-----