title: SHIFT+F9 in macro and macro refreshing speed
body: <p>I made two linked macros. </p>
  
  <p>One of them generates copies of a certain sheet in a workbook. The problem here is that I need to press shift+f9 in all the copied sheets to update my values. I have already used calculate and application.calculate = xl......</p>
  
  <p>Second macro calls the values of the first macro and performs operation on that. The problem here is that after running the first macro and using shift+f9, updating all the sheets..if I run this second macro using an assigned button it does not run but if i step into the macro and run it step by step it runs properly. </p>
  
  <p>I think it's because the values of first macro take time to refresh hence this problem occurs..</p>
  
  <p>Macro1: </p>
  
  <pre><code>Sub macro1()
  Worksheets("Excel Inputs").Activate
  If Sheets("Excel Inputs").Cells(11, "P") = 3 Then
      Sheets("Valuation 02").Delete
      Sheets("Valuation 03").Delete
  ElseIf Sheets("Excel Inputs").Cells(11, "P") = 2 Then
      Sheets("Valuation 02").Delete
  End If
  Length = WorksheetFunction.CountA(Range("B13:B15"))
  For i = 1 To Length - 1
      Sheets("Valuation 01").Copy After:=Sheets(4 + i)
      Sheets(4 + i + 1).Name = "Valuation 0" &amp; (i + 1)
      Application.Calculation = xlCalculationAutomatic
  Next i
      Sheets("Excel Inputs").Cells(11, "P") = Length
  End Sub
  </code></pre>
  
  <p>Can anyone help me on this ? </p>