Git a problem with Data Validation.
In column A rows 1-10 hold values, then for row 11 I've set the DV to "look
up" the range 1-10 for values to use - so far so good.

When I copy A1 and paste downwards for the next 100 rows, the DV "adds" 1 on
to the range ie for row 12 the range is specified as 1-11, for 13 1-12 and 14
1-13 etc.

I've tried a straighforward paste, as well as a copy and format paste but it
doesn't change.

Other columns I've done this with are fine - I just can't see what the
problem is with this column - I could rewrite it all out but I'd prefer to
know whats going wrong...

Thanks