title: Copy and paste on multiple sheets in Excel using VBA
body: <p>I am using the following code to loop through all my worksheets copying and pasting the same values on all.</p>
  
  <p>The trouble is my code only applies the changes to the Active sheet.</p>
  
  <pre><code>Sub Button4_Click()
  
  Dim WS_Count As Integer
           Dim I As Integer
           WS_Count = ActiveWorkbook.Worksheets.Count
  
           ' Begin the loop.
           For I = 1 To WS_Count
  
      Range("C10").Select
      Selection.Copy
      Range("C11:C300").Select
      ActiveSheet.Paste
      Range("C10").Select
  
           Next I
  
  
  End Sub
  </code></pre>
  
  <p>How can I configure my code so that it is applied to all sheets in the loop?</p>
  
  <p>Thanks</p>