On Sun, 28 Nov 2004 11:52:05 -0600, "Don Guillett"
wrote:

why not try just
with range(yourrange).font
.ColorIndex = 0
.Bold = False
End With

Thanks to everyone for the help. The macro now works almost
instantaneously. Even if I leave screen updating on, it only takes a
fraction of the time it used to take. Sweet!

Is there a way to assign the values in a range of cells to an array in
a single statement? If that is possible, I could eliminate all loops.

Thanks

--
Email: Usenet-20031220 at spamex.com
(11/09/04)