Thanks especially for the general tip, which I'm sure will be helpful. When
I say I'm a newbie this was literally the first time I'd tried to use VBA!
The code you suggested doesn't quite do what I wanted on this occasion - I
needed to use paste special to pick up only values - but I'm storing it away
for future use.