I have a macro that is inserting lines on 2 sheets in another workbook. The
other workbook has 10 sheets. 1 sheet contains the data and the other 9
sheets contain many formulas that are all inter-connected with the various
sheets. The lines are inserted in the data sheet and in 1 of the other 9
sheets. The other 8 sheets are not changed at all

The problem is when I insert a row on either of the 2 sheets, it takes
forever. I have tried changing calculation to manual and then turning it
back on to automatic when I'm done running the code but that doesn't seem to
help.

I would appreciate any suggestions to speed up the row insertion process.
Thanks for your help......
--
JT

You can turn off screenupdating at the start of your macro and turn it
on again before 'End Sub'

Post your code for further comments.

Regards,
Per

On 13 Jan., 16:18, JT wrote:
I have a macro that is inserting lines on 2 sheets in another workbook. *The
other workbook has 10 sheets. *1 sheet contains the data and the other 9
sheets contain many formulas that are all inter-connected with the various
sheets. *The lines are inserted in the data sheet and in 1 of the other 9
sheets. *The other 8 sheets are not changed at all

The problem is when I insert a row on either of the 2 sheets, it takes
forever. *I have tried changing calculation to manual and then turning it
back on to automatic when I'm done running the code but that doesn't seem to
help.

I would appreciate any suggestions to speed up the row insertion process. *
Thanks for your help......
--
JT

Forgot the code....

Application.ScreenUpdating=False

---
Per

On 13 Jan., 17:07, Per Jessen wrote:
You can turn off screenupdating at the start of your macro and turn it
on again before 'End Sub'

Post your code for further comments.

Regards,
Per

On 13 Jan., 16:18, JT wrote:



I have a macro that is inserting lines on 2 sheets in another workbook. *The
other workbook has 10 sheets. *1 sheet contains the data and the other 9
sheets contain many formulas that are all inter-connected with the various
sheets. *The lines are inserted in the data sheet and in 1 of the other 9
sheets. *The other 8 sheets are not changed at all

The problem is when I insert a row on either of the 2 sheets, it takes
forever. *I have tried changing calculation to manual and then turning it
back on to automatic when I'm done running the code but that doesn't seem to
help.

I would appreciate any suggestions to speed up the row insertion process. *
Thanks for your help......
--
JT- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -