Remove this line

OldCell.Borders.LineStyle = xlLineStyleNone


Gord

On Tue, 2 Sep 2008 06:59:15 -0700, JWeaver
wrote:

Thanks, Gord!

That worked to color the cell, however, it wiped out my cell border I had in
place. Can I modify the code you specified to put back the cell border? I
can't set up to print gridlines because it puts lines where I don't want them
on the Form.

Thanks!!