Not without some sort of VBA code/macro.

Sub cutanddelete()
With ActiveSheet
ActiveCell.EntireRow.cut Destination:= _
Sheets("Sheet2").Range("A1")
ActiveCell.EntireRow.Delete
End With
End Sub


Gord

On Fri, 1 Dec 2006 11:14:01 -0800, shertone
wrote:

so, are you both thinking there is no way to do this between sheets?

Sherry

"HALinNY" wrote:



"Gord Dibben" wrote:

HAL

Which version of Excel removes the row when row is cut and pasted elsewhere?

None that I have ever used from 5.0 through 11 will delete a cut row without the
going-back-and-deleting step.



By golly, you are right, Gord. It works on the same sheet but not on a
different sheet.

My apologies for not testing what I described before offering it.

B+
HALinNY


Gord Dibben MS Excel MVP