Run time error - Method range of object failed message when trying to cut entire row

I am new to excel macros and VBA. Here's my code. I'm trying to cut a row and paste it after the last cell in the previous row. It's getting hung up on the fourth line of the code.

Please Login or Register  to view this content.

Any help would be appreciated.

Hi almilw,

before you look at
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Edit your post by clicking on the green "Edit" button below your message. Then click on "Go Advanced", Select the code in the message and click on the "#" icon just above the message. This will put code tages around your code and make you a better poster on the site.

After doing the above look at the possible things that can go after End.

Hi almilw,

There are only 4 things that can go in the () after .End, they would be: xlUp, xlDown, xlToRight or xlToLeft.

Based on your pseudo code above I believe you wanted to do a.

Please Login or Register  to view this content.

I hope that helps.

You cannot paste an entire row to anywhere other than column A, since it won't fit.