Toppers,

It worked! (of course it did)
Many thanks!

Now, If you could give me one more that would allow a user to click a radio
button and email a just a particular sheet...not the entire workbook, that
would be cool!
Thanks again for your valuable time.

"Toppers" wrote:

Rob,

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Worksheets("Sheet1").Range("C1:C10").Copy Worksheets("Sheet2").Range("G1")
End If
End Sub

HTH

"Robb27" wrote:

I made a checkbox but I need to know how to make it when checked, it will
copy a range of cells to another sheet in the same workbook. Can anyone give
me a sample to get me started? Thanks in advance.

Rob