On Wed, 4 Nov 2015, Schene, Chris wrote:
I am using the code below to create a very large spread sheet that is 47
rows wide.
There are a few very large strings in the rows, but for the most part the
data is fairly small.
If the .xls file is over about 1000 rows I get an error when I load the
.xls file in excel saying it needs to repair the file and I lose all the
row color and column width settings.
Cell Styles are workbook scoped, not cell scoped. Make sure you create all
of your styles outside of the loop, and re-use them. If you create one
style per cell, you'll use too many and Excel will sulk....
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
