Colin Hayes brought next idea :
BTW Curiously when I effect the same change manually (F5 - Special -
Blanks -
Edit - Delete - Entire Row) it leaves 4359 rows from a worksheet with 8546
rows. Using the macro it leaves 4244 lines from the same worksheet. This
is a
little mysterious , I find. The worksheet has no formulas or merged cells
or
false spaces in cells.

Another thought...

The code acts on the UsedRange. Not sure what F5 acts on and so the
code might remove more if UsedRange extends beyond the actual data. You
can find the last row/col limits via 'Ctrl+End'!


Hi Garry

Some very interesting results. I used the manual F5 method and it selected
all the blank cells in the worksheet. I then deleted the whole row for each
and it left 4539 rows as before.

I then used the F5 method again on the amended worksheet and it found more
blank cells! This is very curious , as I thought all the blanks would have
been selected the first time around. On deleting the whole row for each , it
left 4244 rows. This is the same as the macro leaves.

I'm sure there must be a logic for this phenomenon. Clearly the macro
achieves the same result as the manual method , but does it in one pass
rather than two.

Ctrl-End does find the bottom right extremity of used range , as it should.

That's interesting to know! Thanks for reporting back...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion