View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default CUT not COPY but errors

What is making this Cut snippet error?

I've tried:

cG.Row.EntireRow.Cut
ActiveCell.EntireRow.Cut

I had it in my mind Cut or Copy could be used interchangeably.
My cheat sheet and Google are woefully short on examples.

Thanks.
Howard

With ActiveWorkbook.Worksheets("Sheet1")
Set Grng = Range("G1:G" & .Range("G" & Rows.Count).End(xlUp).Row)
For Each cG In Grng
If cG = "X" Then
cG.EntireRow.Cut
Sheets("All Other").Range("A" & Rows.Count).End(xlUp)(2).PasteSpecial
End If
Next
End With