Try this
![]()
Sub steffen On error resume next Do Sheets(1).Columns(10).Find("Active",,xlValues,xlWhole).EntireRow.Cut Destination:=Sheets("Active").Range("A60000").End(xlUp).Offset(1,0) Loop until err.number <> 0 End sub
Try this
![]()
Sub steffen On error resume next Do Sheets(1).Columns(10).Find("Active",,xlValues,xlWhole).EntireRow.Cut Destination:=Sheets("Active").Range("A60000").End(xlUp).Offset(1,0) Loop until err.number <> 0 End sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks