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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 04:33 PM.