not paste the formatting

[snooze24]

I've looked and seen some ideas but I can not put the coding together myself because I only slightly understand what I'm doing with VBA. Basically I want this macro to only cut and paste the text without the formatting. The macro is supposed to cut from one worksheet and paste to another worksheet in the first available spot, however its taking the formatting with it.

Please Login or Register  to view this content.

Thanks in advanced, sorry for the simple question but I tried searching and have been unable to figure this out.

[shg]

Maybe like this:

Please Login or Register  to view this content.

[tony h]

If you leave out the destination then the cut is to the clipboard.
set another object to point to the destination and use pastespecial to paste the info you want:

eg:

Please Login or Register  to view this content.

[snooze24]

Shg, Your code keeps the formatting but it strips away my combo box, I don't know how to make a code to add the combo box back

Tony H, I'm not sure I understand where to insert that piece of code. I haven't been able to get that to work.

I really appreciate it!

[shg]

but it strips away my combo box,

What combo box?

[snooze24]

Well I have a combo box in the cell that is being moved to the other worksheet. I need to leave the combo box behind and just transfer that cell values to the other sheet.

I'll explain it again and try to be clearer. I have a sheet the columns are "Item, Date, Price, Status" Under the status column there is a combo box that has the options of choosing "Sold" or "Available" When the status is changed to Sold I want to move the contents of the cell to another worksheet, Lets name it "Customer Sold". The code I'm using right now moves the Cells over but it takes away the combo box and the color.

I'm using the count if function to track the number of available items and the number of sold items, and the only way I can get the countif function to differentiate between Sold items and Available items is by moving the sold items to another sheet.

Hopefully this makes sense. This is the last bit of info I need to have this sheet up and running. I really appreciate all input.

[snooze24]

Alright so I was able to do some searches and put together a code that will Copy and paste special and only paste the values. But it seems like you can only paste Special when you copy, So the macro doesn't move Sold items and just copies them into the other worksheet. Is there a code I could add that will clear the contents of the Cells that where copied.

Please Login or Register  to view this content.

End Sub

Basically this works but i need the cells that where copied to be blank so it appears it has been Cut. But I still need to keep the combo box and the color so I can't just delete the Row. I hope this makes sense.

[shg]

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[snooze24]

sorry bout that.

[snooze24]

So I adjusted the code to clear the contents of Items listed as sold after it copies the info to the ShirinSold worksheet. But for some reason there is a whole new set of problems. Now if 2 items are sold it only pastes 1 item and it will over right anything that was in the 2nd row of ShirinSold and will not paste to the next available row. I really thought this was going to work but am out of luck

Please Login or Register  to view this content.