whats wrong with my code

**comp23** · 07-11-2012, 05:33 PM

i HAVE THIS CODE BELOW

Please Login or Register  to view this content.

However I don't want it to copy instead I want it to cut however when I do this it goes wrong

Please Login or Register  to view this content.

**TMS** · 07-11-2012, 05:38 PM

With your post count you are looking at an infraction unless you modify your thread title and add code tags ... please read the forum rules.

Regards, TMS

**comp23** · 07-11-2012, 05:42 PM

no doesn't work as soon as i add cut to the code it goes wrong

**dangelor** · 07-11-2012, 05:43 PM

Excel does not allow you to paste only values when you 'cut' (try doing it manually to see).

Try using copy and then add a line of code to clear the contents of the original range.

**arlu1201** · 07-12-2012, 04:59 AM

comp23,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.