See if you can adapt what I explained in this thread. http://www.vbaexpress.com/forum/showthread.php?t=26541