hi Duncan,

Am Fri, 14 Dec 2012 04:14:12 -0800 (PST) schrieb Duncs:

I've put it into the spreadsheet and modified accordingly. I perhaps didn't explain fully in my original post and for that, I am sorry. I should have added that I won't be copying the entire column. Instead, I will only be copying a section of the text...e.g. the range A1...H1. Then, the next time with may be A10...H19.

The size of the area I am copying will vary each time I want to copy. I've looked at selecting the required range, identifying this range, and copying the data from within this area. I then need to copy the values to a different location each time...e.g. the first paste may be at A1. The next may be at A17, then A23 etc.

I think the selected range method may be the best but as I say, I can't get the method for it.

if the copied ranges and the paste locations are so different, you can't
do it automatic. If the paste location is the same range as the copied
range but on another sheet, you could do it with a macro.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2