Paste Problem

[ajocius]

Group,
Below is an excerpt from my VBA project. At home this runs quite
fine using Excel 2002. But here at work I get the following error
message. What must I do to resolve this error.

Error Message: Runtime Error 1004: PasteSpecial method of range class
failed


Line before, line and line after below.


'*****************************
wb3.Activate

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

Application.CutCopyMode = False

'*****************************

The second line above is highlighted when I select Debug from the error
box.


Tony

 

[Guest]

Make sure that the selection is what you want. Before pasting try:

Dim s As String
s = Selection.Address
MsgBox (s)

Do this both at home and at work.

 

[Guest]

This is just a guess, but you may need a line continuation character (space
underscore.) Since you refer to line as a separate line, I suspect this may
be the case.
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False

 

[Ankit Wadhawan]

Hi,


This error generally comes when you don't copy any thing before pasting.
You must copy the range (Data) bfore pasting it by using "pastespecial"
command.


Ankit,
India