Hi Bob,
The problem is that you are selecting cells, there should
be no need to select cells which moves the things around
on the screen.

At least you turned off screen updating in your macro, which
will save you some time. You should also turn off calculation
which will make the code go faster by not having to update
cells until you are finished.

See http://www.mvps.org/dmcritchie/excel/slowrespl.htm

You can see some examples of working through cells
without actually changing the selection or active cell in
http://www.mvps.org/dmcritchie/excel/join.htm
and in
http://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm