title: VBA excel copy cell comment and past it onto a new sheet without using clipboard?
body: <p>Hello my goal is to copy a comment, of a cell without having to use the clipboard (or all that added code :D) im still new to VBA so sorry for any errors :D</p>
  
  <p>I was trying to use this code below it works great on cells but im not sure if it works on comments to </p>
  
  <pre><code>Sheets("Dump").Range("A1").Copy Destination:=Sheets("RR").Range("K1")
  </code></pre>
  
  <p>i try to change it around a bit but it gave me an error "application-defined or object-defined error"</p>
  
  <pre><code>Sheets("Dump").Range("A1").CopyComment Destination:=Sheets("RR").Range("K1").AddComment
  </code></pre>
  
  <p>ty for any help one can give </p>