Hi Tom,

You're so right about the other things causing cells to not be emptied
The problem, at least for me, was always that I never set or use thos
things like fontsize, type, borders, etc. The only thing I did was t
enter a number or text in cells. Apart from that, if you use a comman
like .clearcontent you would expect a cell to be empty / unused but i
isn't.

Nowadays I use, also for this, a workaround to the actual problem b
using .specialcells(xlconstants) to select and clear in combinatio
with the code courtesy of DJR during quiting to delete empty rows.

This does help but debatably should not have to be used.

Haven't tried your initial suggestion yet but will post when I do.

Best regards,

Leo

--
droopy928g
-----------------------------------------------------------------------
droopy928gt's Profile: http://www.excelforum.com/member.php...fo&userid=3023
View this thread: http://www.excelforum.com/showthread.php?threadid=53771