Thanks Donna (and thanks Tom, although I used Donna's as she was there first!)

My colleagues all think I'm some kind of Excel genius now... I'm not gonna
tell them it's you guys who are the real geniuses!

Many thanks

Phil

" wrote:

Copy and Paste Special in seperate operations. eg...

Selection.Copy
Sheets("Sheet2").Select
Range("A3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False