title: VBA Paste and on Error display msgbox
body: <p>I am sorry as this has been probbably discussed many time here. I have got following problem. This macro should paste from clipboard to cells(1,1). And if there is no data in clipboard, I would like it to display msgbox with test "Nothing to paste".</p>
  
  <p>What this keep doing is on error it will enter in cell(1,1) text: "MsgBox "Nothing to paste"" instead of displaying message.</p>
  
  <p>Could you please help me correct mistake? Many thanks in advance!!!</p>
  
  <pre><code>Sub Paste()
  
  Cells(1, 1).PasteSpecial
  
  If Err Then
  MsgBox "Nothing to paste"
  End If
  
  End Sub
  </code></pre>