No, it was set to automatic. I've got it working now. Thanks so much.

"Niek Otten" wrote:

Calculation set to Manual too?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Alex" wrote in message ...
| Thanks Mike. I already have screenupdating turned off/on. It still slow.
|
| "Mike H" wrote:
|
| Alex,
|
| Presumably the formula are already in column P and calculation is set to
| automatic so calculation will begin as soon as a line of data are populated
| so this 'may' help
|
| Application.screenupdating=false
|
| your code
|
| Application.screenupdating=true
|
| Mike
|
| "Alex" wrote:
|
| I have the following formula in 5000 cells in column P in my worksheet.
| =IF($O2<"",NETWORKDAYS(O2,N2),"") Using a module, I'm importing the rows
| that contain data in columns A:O. After the rows have been imported into the
| worksheet I can see the above formula calculating. The problem is that it is
| extremely show, approximately 2 seconds per row. Is there a way I can speed
| this up? Thanks for your help.