Cheeky, Wasn't sure weather this belonged as a post in the http://www.excelforum.com/excel-gene...-possible.html thread as Andrew-Mark has or not. I too would also be interested in seeing how "Union" is used to accomplish this type of task.