Anyone come across this before. This code has worked fine in the past, but I
have one particular sheet which behaves very strangely.
I have

Dim ThisRow as Range

and am working down one sheet, collecting data, and moving some parts to
another. (src - source, dest - destination)

The 'business' line is:

Set ThisRow = wsSrc.Range("A" & nDRow).EntireRow '{nDrow is my data row}

then

wsDest.Range("AG" & nDRow) = ThisRow.Range("AB" & nDRow).Value

should take the value from wssrc cell AB5 and put it into wsDest cell AG5.

What it actually does is take the data from cell AB9
When nDrow is 6, my data should come from AB6, but it actually comes from
AB11, and when ndrow is 7, my destination data comes from row 13. - In each
case from the correct column.

Any idea what is going on here? I'd have though this ought to be impossible.
The only reason I've found it was that my data integrity check reported a
problem, and I could find nothing wrong with the orginal row (6339). I
spotted that the name wasn't right, and finally found the duff source data in
row 12667.

As far as I can tell, this only happens with one of my source sheets, but my
confidence is a bit shaken!!!

Any thoughts appreciated.