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").c learcontents

would be the line that did the real work.

Richard wrote:

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!!!

--

Dave Peterson

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

"Dave Peterson" wrote:

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

would be the line that did the real work.

Richard wrote:

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!!!

--

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




Richard wrote:

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

"Dave Peterson" wrote:

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

would be the line that did the real work.

Richard wrote:

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!!!

--

Dave Peterson


--

Dave Peterson