calculation

J

JT

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......
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
selecting workbook/sheet 3
Code copies twice...? 13
Need Help with a VBA subroutine 0
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
filter function 0
VBA dropdownlist to put in cell's comment creates runtime error whenthe dropdownlist is above 266 li 0
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Top