On Fri, 21 Feb 2014, alefevre wrote:
In fact i have files with thousands of cell to transfert and method on boder (SetBorder & SetBorder color) take 3 ms to 5 ms to execution each on 1 cell. In my context 1300 thousands it takes 30 sec to execute.
Cell Styles are workbook scoped, not cell scoped. You should create the ones you need upfront, then apply these to cells. Don't create one style per cell!
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
