title: Copy/Paste Macro Pasting Randomly
body: <p>I am having an issue copying and pasting a drop-down data validation menu from one sheet into all selected sheets. The drop-down menu seems to paste randomly instead of pasting into sheet "B22" of the selected sheets.</p>
  
  <pre><code>Sub TEST()
  Dim sht As Worksheet
  Sheets("Sheet2").Range("B22").Copy
  'Sheets selection should be done before running macro
  Selection.Range("B22").PasteSpecial xlPasteValidation
  Application.CutCopyMode = False
  End Sub
  </code></pre>
  
  <p>Any suggestions on how to tackle this? I am having some difficulty finding the error in my code.</p>