Command button

[Richard]

I have a command button that when clicked I want it to delete the contents
from Sheet1 D1, Sheet1 B3:B100 and Sheet1 D3100. Thanks in advance!!!

 

[Dave Peterson]

worksheets("Sheet1").range("d1,b3:b100,d3:d100").clearcontents

would be the line that did the real work.

 

[Richard]

Thanks that works perfect!! Can you also copy Sheet2 Columns, A,B,C to sheet
3 once clicked. Thanks in advance!!

 

[Dave Peterson]

You want to copy 3 whole columns and put them where? This copies those 3
columns and plops them over A:C of sheet3.

worksheets("sheet2").range("a:c").copy _
destination:=worksheets("sheet3").range("A1")

If you wanted the values--not formulas:

worksheets("sheet2").range("a:c").copy
worksheets("sheet3").range("A1").pastespecial paste:=xlpastevalues