Hi Tom,

Thanks for the reply.

I'm not at work at the moment but am surely gonna try this tomorrow.
The application though I've made was started and written using
excel2003. Only a couple of months ago did I once open and work on it
in excel2000 but since then I've also upgraded my homecomputers to
excel2003. Let you know though as this one really had me puzzled.

As for the usedrange bug, maybe I referred to it wrongly but what I
meant was for workbooks to become bloated over time without any
significant reason. This occurred to me also and ended up with a
workbook of 7.5MB. Searching this forum I found a simple routine with
which I could reduce it to 700KB. Apparently excel didn't release
empty cells properly for which the only solution was to delete empty
rows and then saving the sheet again.

Thanks again and best regards,

Leon


--
droopy928gt
------------------------------------------------------------------------
droopy928gt's Profile: http://www.excelforum.com/member.php...o&userid=30232
View this thread: http://www.excelforum.com/showthread...hreadid=537711