Command button
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!!! |
Command button
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 |
Command button
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 |
Command button
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 |
All times are GMT +1. The time now is 02:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com