im getting a problem -

'Run-time error '1004':

Paste Special Method of Range Class failed

Problem code is

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

it works sometimes tho - basically the code opens up a workbook - adds a new
sheet and pastes the values into cell A1.

any ideas?

thanks,