Try this code
![]()
Sub DeleteScrolls() Dim I As Long For I = Cells(Rows.Count, 1).End(3).Row To 1 Step -1 If Cells(I, 1).Value Like "*ActiveWindow.ScrollColumn*" Then Rows(Cells(I, 1).Row).Delete Shift:=xlUp End If Next I End Sub
Try this code
![]()
Sub DeleteScrolls() Dim I As Long For I = Cells(Rows.Count, 1).End(3).Row To 1 Step -1 If Cells(I, 1).Value Like "*ActiveWindow.ScrollColumn*" Then Rows(Cells(I, 1).Row).Delete Shift:=xlUp End If Next I End Sub
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks