Maybe there's nothing to paste???

I'd add line:

if application.cutcopymode = false then
msgbox "nothing to paste"
exit sub
end if


There's lots of things that cause the clipboard to empty. Maybe you did
something or maybe an event macro fired???

Phil Davis wrote:

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

--

Dave Peterson