Hello, I must be using the wrong wording in my search for a solution here. I want my Range to be the highlighted rows. All I am finding is info on the Range based on a selected cell. Thanks
Quote:
Sub DeleteBlankF2Rows()
Selection.AutoFilter
ActiveSheet.Range("$A$8:$Y$48").AutoFilter Field:=3, Criteria1:="="
Selection.Delete Shift:=xlUp
End Sub
|