Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2018, 11:03 AM
14spar15 14spar15 is offline Set Range based on selected rows. Windows 7 64bit Set Range based on selected rows. Office 2010 64bit
Competent Performer
Set Range based on selected rows.
 
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default


Example - Rows 1-20 contain data. Cell C5 is blank and cell C15 is blank. If rows 10-20 are selected (highlighted) and the macro is run row 15 would be deleted because cell C15 is blank and it is in one of the selected (highlighted) rows. Row 5 is not deleted because it was not one of the initial selected (highlighted) rows. Part of the problem here is I don’t know that for sure “selected” and “highlighted” is one in the same. Also is this related to “Selection” in the coding terminology? Sorry I can explain this better.
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 06:13 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