>I have WAIT WINDIW NOWAIT “Populating cell 'n' FROM 'ns'”
>before creating and formatting every cell in loop. It took less than 1 second for every cell in EXCEL 2000, and at least 6 seconds in EXCEL 2007.
>Trying to step through program didn’t give me any additional information.
>Looks like every single step works slover.
(1) I would take out the Wait window or at least don't do it for each cell - but for each row
(2) Nowadays, with multi core processors, it goes a lot faster than with single core processors
(3) How do you populate the cells - some code ?
Gregory