Command button

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have a command button that when clicked I want it to delete the contents
from Sheet1 D1, Sheet1 B3:B100 and Sheet1 D3:D100. Thanks in advance!!!
 
worksheets("Sheet1").range("d1,b3:b100,d3:d100").clearcontents

would be the line that did the real work.
 
Thanks that works perfect!! Can you also copy Sheet2 Columns, A,B,C to sheet
3 once clicked. Thanks in advance!!
 
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
 
Back
Top