Set Range based on selected rows.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Set Range based on selected rows.

FAQ

Thread Tools

Display Modes

11-17-2018, 09:40 AM

14spar15

Windows 7 64bit Set Range based on selected rows.

Office 2010 64bit

Competent Performer

Join Date: Mar 2011

Posts: 100

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Individual Rows in a range	Phil H	Excel	3	11-05-2018 12:09 PM
Import a specific range (bookmarked section) from all Word docs in a selected folder	Greengecko	Word VBA	5	06-14-2016 07:54 AM
Find and Delete Rows based on a range	damaniam	Excel Programming	2	03-12-2014 06:06 AM
How to remove blank rows from a specified range?	Learner7	Excel	1	04-19-2011 02:45 AM
Temporarily show/hide selected table rows	glricht	Word Tables	0	12-29-2009 05:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 AM.