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

Code copies twice...? 13
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
When found add it to the last and display total in Msgbox 23
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook 2
Copy columns and paste with blank column between 5
Sheet name changing dilemma 2
Duplicate procedure in other sheets 2

Top