Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating copy of sheet into new file results in #REF errors | Excel Discussion (Misc queries) | |||
Copy column to another spreadsheet but get value errors | Excel Discussion (Misc queries) | |||
Copy / Paste Errors | Excel Programming | |||
Copy from recordset errors in ADO | Excel Programming | |||
How avoid errors when you Copy chartobjects paste in powerpoint | Excel Programming |