Shoutbox

If you want to copy the contents of a certain cell to the clipboard, use

code:

---

Private Sub CommandButton1_Click()
Range("B2").Copy
End Sub

---

But replace B2 with whatever cell you need.

Is this what you're looking for?