Thread: [Solved] Remove rows less than 10
View Single Post
 
Old 07-15-2014, 09:07 AM
WeDonNeedNoSteenkgRibbons's Avatar
WeDonNeedNoSteenkgRibbons WeDonNeedNoSteenkgRibbons is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2014
Posts: 23
WeDonNeedNoSteenkgRibbons is on a distinguished road
Default

Sometimes it's helpful to use macro recorder and "steal" from that. I'm not doing that specifically now, but it is how I learned ".EntireRow."

You'll need some wraparound code to cycle through your .UsedRange or some range (such as built from column D) or even Range("D: D"). (remove the space. I can't stop the forum processor from making an emoticon if I leave it in.) At any rate the main thing will be, assuming you have a cell represented by c with
dim c as range

then try this:
if (c.value<10) then c.entirerow.delete

Maybe you'll have
for each c in ...
where you specify the range with ages, as mentioned earlier.
Reply With Quote