Dave,

thanks! Your code worked great this time! It did get rid of a lot of
the squares!
However after a while of processing it gave me an *OUT OF MEMORY
ERROR*.
I have uploaded a _screenshot_ of it here-
http://www.freewebs.com/bxc2739/

The problem is *my excel file is very large*, (both in terms of
individual cell sizes, and also in terms of the number of raw cells
itself) When I go down to around
7000 or so, the boxes are all still there.

If this is a memory problem, how can I specify that the macro does
different sets at a time?? (Otherwise I can run it over and over again,
but the onces not modified will still remained not modified and that is
not very good)

edit/note: what I meant was, your macro seems to get rid of the squares
at 1000 cells at a time, after which excel gives an OUT of MEMORY error.
I except this is a hard limit in Excel and there is not much that can be
done about it.
*_But_could_you_script_the_macro_so_that_I_could_s pecifiy_which_range_to_do?_*
(ie 1-1000, then 1001-2000, etc..) That ways I can overcome the
memory/size limitations and still get the entire (20,000) file
processed!
(other than this you macro works prefect!)

Thanks,
Bo


--
bxc2739
------------------------------------------------------------------------
bxc2739's Profile: http://www.excelforum.com/member.php...o&userid=32538
View this thread: http://www.excelforum.com/showthread...hreadid=523549