I have one other question related to this. If I only wanted to retain the rows in which there was a certain value within it how would that be done? Make a sub array (from the main array) of the rows that contain this value and then send this to a range on a worksheet.

David