Yes - because I'm sloppy and posted air code! It should be wksDest.
Is that still the case if you make the above adjustment?Longer problem - second time it gets to case A, it still overwrites the data we got first time round.
Note: I assume you intended to copy to the next blank column, not row?
Bookmarks