View Single Post
 
Old 11-17-2018, 09:40 AM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Set Range based on selected rows.

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
Reply With Quote