Ideally you should not have got the same error, had you used the code that I
gave you. Still I would urge you to use the following code
Worksheets("Sheet1").Cells(1, 1).Select
ActiveCell.EntireRow.Copy
Worksheets("Sheet2").Cells(1, 1).PasteSpecial xlPasteAll
If still the error persists, then please send the file to me. I need to take
a look at the entire code and see if the same error can be re-produced on my
side using that code.
Regards,
Ajit
-----Original Message-----
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: Monday, December 01, 2008 5:00 PM
To: MS Excel & VBA Macros
Subject: $$Excel-Macros$$ Re: Paste Error 1004
Hi Guys, thanks both for your replies.
However I have tried them both and get the same error code,1004.
I am using Excel 2007 with VB version 6.5. Is there something crazy
settings or something causing this?
Thanks CL
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
