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