Okay thanks,
So i getWhich works after selecting what i want. So i just need to change it by adding in the range i want to delete so it does it automatically?![]()
Sub DeleteRow() ' ' deleterows Macro ' ' ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 Selection.Delete Shift:=xlUp End Sub
Bookmarks