bunty.
You keep moving the goalposts. I can't see your workbook but it sounds like it could be easier if you copied the whole range, in other words all columns, over. Is that right?