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.
|