My interpretation of his post was that he was going through a range clearing
the borders from cells. My solution, without giving the specific code just
yet, was to just do it all at once without looping at all. I don't see why
that is so useless without knowing more, but the OP seemed offended that I
had wasted his time with such a suggestion and proceeded to give me a
lesson. I'm trying to help and I don't need a sanctimonious OP implying that
my help was stupid. I've been coding for a few years now and feel that I
have some idea of what I'm doing, otherwise I would not have responded,
potentially setting an OP in the wrong direction. Thank you, Myrna, for your
polite support of my attempt to help.
Richard Choate
Your statements re With/End With being useless may be true for this
particular code, but in
general this syntax can improve the execution speed. MS has published data
describing how much
improvement you get for each "dot" that you remove.