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

I'll try that. My code was obtained by modifying code from recording a
macro.

And "yourrange" can be any rectangular range, right?

That will work for resetting all of the cells to the same value, but I
also need to examine each cell value. Actually, store it in an array.
Is there a way to store an entire range (column) in consecutive
elements of an array with a single statement?

Thanks

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