Hi!

My first post here..

I have to write 5000 rows to an Excel spreadsheet.
Each row is distinct, and is received from a server. The writing of th
rows themselves is not a problem however. (I'm setting the row range t
a variant array)

Here is my question.. I also have to color the row and lock it down
depending on the information in the row itself. Currently, we check th
criteria of the row at the time when we add it onto the sheet, and loc
it and color it at that point. Naturally screen updates are turned of
for the processing of all 5000 rows!

However, I recently thought of another way to do it, where I have
LockDownRange which I union with the row range if it meets the loc
down criteria. Then after processing all 5000 rows, I call one singl
lock down on the LockDownRange. Ditto with the ColorRange

Is the second method going to be any faster

--
Message posted from http://www.ExcelForum.com