Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using Excel 2007. I'm trying to cut a value if it is negative and move
it to a different column. The following cuts the value but I can't get it to paste: Range("N2").Select If Selection.Value < 0 Then Selection.Cut ActiveCell.Offset(0, -1).Select This is some of what I have tried but none work- 'Range.PasteSpecial.xlPasteValues 'ActiveCell.Pastetype.Pasteall 'ActiveCell.PasteSpecial Paste:=xlPastevalues, operation:=xlNone, _ 'skipBlanks:=False, Transpose:=False It moves to the proper cell but I can not get paste, xlpaste to work in any variation that I have tried. What is the correct paste command? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
Automating copy/paste/paste special when row references change | Excel Programming | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming |