Remove rows less than 10

jolivanes · #10 07-16-2014, 03:45 PM

Hi Novice.
I appreciate your explanation.
As they say, you're never too old to learn. And am I ever getting up there!!!

Quote:

Joli, if there was a missing item in the middle, an empty cell, the End-up approach would only go that far.

Do us a favor and fill a bunch of cells in Column A, leave some empty and run this

Code:

Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row).Select

As far as your named range is concerned, how would you make it variable in case more info is added to the bottom?

Quote:

if you do "for each" with a range, you don't have to start from the end and work up

I have never heard of this either.
Have you had a chance to try it?
I would like to see it but I have to go now (Happy Hour).
Let us know the result if you would have multiple rows, like rows 4, 5, 6 and 7, that need deleting.
Thanks again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM
rows in word?	j2b3	Word Tables	3	07-19-2012 03:59 PM
merging rows and creating sub-rows	gib65	Excel	2	12-09-2011 02:09 PM
How to remove blank rows from a specified range?	Learner7	Excel	1	04-19-2011 02:45 AM