Thread: [Solved] Remove rows less than 10
View Single Post
 
Old 07-16-2014, 03:01 PM
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

Joli, if there was a missing item in the middle, an empty cell, the End-up approach would only go that far. If you e.g.
Code:
dim c as range
for each c in range("AllAges")
etc.
or otherwise use range("AllAges"), then, as long as the range is correct, you'll get everything.

But I'll admit the using the filter and deleting that way is likely to be far far faster than walking every item in the range one by one.

On the other point, if you used the named range, there would be no hardcoded 4 in the code either.
Reply With Quote