Macro - Run-time Error '1004': Application defined or object defined error

Hey,

I am trying to write a macro that cuts a row based on the users selection and pastes it under a title on the same worksheet. The macro actually works correctly, but errors out at the same time. It errors out on "ActiveSheet.Paste" Here is what I have

Please Login or Register  to view this content.

Thanks a lot in advance for any help, its appreciated.

Hello robby10,

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code using the # icon
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

To manually wrap your code, use these Bulletin Board Code Tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


To learn more about BB codes used in this forum, just click on the link below...

Bulletin Board Codes Tags

Hello robby10,

The problem occurs because the Insert method does the pasting. When you execute the ActiveSheet.Paste, the clipboard is already empty. Here is the working code.

Please Login or Register  to view this content.