Cut Cell, PasteSpecial to another sheet Help

[dpalm]

I am extremely new at this and I'm really bad at it so far. I need to macro to cut a cell ("C7") and PasteSpecial it to cell ("A300") on sheet ("Engineering Backlog"). I know it's simple and I've tried many examples but I cannot get the pastespecial to work correctly.

Right now, this is all I have for this macro:

Range("C7").Select
Selection.Cut
Selection.PasteSpecial Paste=xlPasteValues
ActiveSheet("Engineering Backlog").Range ("A300")

Don't know if it matters or not but I'm using Excel 2003.

Humbly, I thank you for the help!

Dave

[Domski]

Hi,

Excel doesn't allow you to Cut and Paste Special so you would need to Copy, Paste Special and then clear the cell.

Please Login or Register  to view this content.

Dom

[Pichingualas]

If all you want is values, why not using simply an = statement:

Please Login or Register  to view this content.

The problem is it won't delete what was in cell C7, if that's what you wanted you will have to add

Please Login or Register  to view this content.

after it.

By the way, the problem you might be having is that you shouldn't put

Please Login or Register  to view this content.

,but

Please Login or Register  to view this content.

.

Also keep in mind that you aren't using the cut paste correctly. It should be something like:

Please Login or Register  to view this content.

Finally, don't forget the Sub End Sub commands before and after your code, like:

Please Login or Register  to view this content.

[dpalm]

Thanks to you both! It's doing exactly what I want.