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