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
|