I'd appreciate any help on this problem that anyone could offer.

I recorded a macro which contains only one line to paste values from one
range of cells into another range. The cells to copy are already selected
(i.e. Cntl-C) and the destination range is also selected BEFORE invoking the
macro.

The code is very simple and looks like this :

Sub Test()
'
' Test Macro

'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

and the Runtime Error 1004 occurs right at the Selection.PasteSpecial ....
line.

This has always worked in the past and from one day to the next it has
stopped functioning. Does anyone have a clue why ??

Thanks in advance.

Phil