Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2018, 11:36 AM
Logit Logit is offline Set Range based on selected rows. Windows 10 Set Range based on selected rows. Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
The first macro I posted will hide the selected rows. It will not delete those rows.

The second two macros posted both do the same thing - delete the rows selected. EXCEPT, "Selection.EntireRow.Delete" deletes rows period. There is no qualification such as an empty cell ... the macro just deletes any row that is selected.

The other "Columns("C:C").SpecialCells(xlCellTypeBlanks).Ent ireRow.Delete" looks at the entire sheet automatically (no need to select any row/s), determines if there is a blank cell in the C column ... and if found, deletes that row.

"Selection" is the same as you clicking on a row number (on the left side of the sheet).
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Set Range based on selected rows. Conditional Formatting Individual Rows in a range Phil H Excel 3 11-05-2018 12:09 PM
Set Range based on selected rows. 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
Set Range based on selected rows. 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 12:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft