Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-30-2018, 07:37 PM
BobBridges's Avatar
BobBridges BobBridges is offline Searching multiple numbers at once Windows 7 64bit Searching multiple numbers at once Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

This looks like a great place for a VBA program. But then, I code at the drop of a hat; if you don't know how and/or don't want to, off-hand I think Pecoflyer's answer is best.

If you want to think about making it a quick program, though, I'd start by guessing that a) you need to do this not just once but occasionally, and b) the 90-or-whatever row numbers you want to delete are contained in some list somewhere—that is, that the program could find those numbers in some other file or worksheet and use them to figure out which rows to highlight. The program stops once they're highlighted, and lets you look them over before deleting them in one or two manual keystrokes. (I don't like to let a new program delete data without giving me a chance to look it over first, at least not until I've done it several times and have learned to trust the routine.)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching multiple numbers at once Wildcards: searching for multiple words / expressions close to each other ballpoint Word VBA 7 11-09-2017 03:30 PM
Excel Index and Match function with multiple criteria not searching the next record mushtaqkadar Excel 3 06-17-2017 12:20 AM
Single value on multiple numbers in row into column T1000 Excel 0 02-14-2017 11:54 AM
Searching multiple numbers at once Searching Multiple PowerPoint & Word Files BobbyAre PowerPoint 14 08-12-2012 06:52 AM
Searching multiple numbers at once searching for text in multiple excel files roytom Excel 2 07-30-2012 01:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 AM.


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