Command button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 12 Mar 2008 01:00 GMT

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

Reply to this Message

Dave Peterson - 12 Mar 2008 01:34 GMT

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

would be the line that did the real work.

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

Signature

Dave Peterson

Reply to this Message

Richard - 12 Mar 2008 03:22 GMT

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

> worksheets("Sheet1").range("d1,b3:b100,d3:d100").clearcontents
>
> would be the line that did the real work.
>
> > 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!!!

Reply to this Message

Dave Peterson - 12 Mar 2008 03:48 GMT

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

> Thanks that works perfect!! Can you also copy Sheet2 Columns, A,B,C to sheet
> 3 once clicked. Thanks in advance!!
[quoted text clipped - 9 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message