Juan Pablo & Aladin provide great solutions to this problem:

http://www.mrexcel.com/board2/viewtopic.php?t=53201