View Single Post
 
Old 04-30-2018, 07:37 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit 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