Set Range based on selected rows.

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

11-18-2018, 10:32 AM

Logit

Windows 10 Set Range based on selected rows.

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

.
You have indicated you are manually selecting the rows to be deleted. This macro will do that :

Code:

Sub DelRows()
    Selection.EntireRow.Delete
End Sub

If you don't want to manually select the rows, but rather have it done automatically, use this macro :

Code:

Sub DelCRows()
    Columns("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

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:11 AM.