I'm looking to choose column B, move down to the last row of data and then delete everything in the last 55 rows from Column B over (A remains stagnant). Right now this is erroring out for me and there may be a much simpler way to do what I'm trying to do. Any help is appreciated.
Range("B2").Select
Selection.End(xlDown).Select
ActiveWindow.SmallScroll Down:=-31
Dim n As Long
n = 55
Cells(Rows.Count, "B").End(XlUp.Offset(1-n).
ActiveCell.Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
End Sub
Bookmarks