Quote:
Originally Posted by Claus Busch
Hi,
Am Mon, 24 Mar 2014 16:54:35 +0000 schrieb sumesh56:
why this macro gives error message?
Runtime error'1004'
Pastespecial method of range class failed.
Sub PasteVal()
Selection.PasteSpecial Paste:=xlValues
End Sub
before you can paste you have to copy.
Try:
Sub PasteVal()
Selection.Copy
Sheets("values").Range("A1").PasteSpecial xlPasteValues
End Sub
Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional
|
thank you very much for the reply. your code gives me error message.
I made a selection of a range in one sheet and went to another sheet click on R3 cell to where i wanted the display .before doing that i have edited the macro 'A1' to R3. the message is
Runtime error '9'
Subscript out of range.