clear column

  • Thread starter Thread starter owl527
  • Start date Start date
O

owl527

hi,
If I want to clear two specific columns on the spreadsheet. How can I
go about doing it? I only know how to clear the entire sheet, which
is:

ws.Cells.ClearContents

what if I just want to delete column A and B? please let me now.
Thanks.
 
ws.Columns("A:B").ClearContents
Regards,
Stefi


„owl527†ezt írta:
 
hint: this will clear sixth column in active spreadsheet:

Columns(6).ClearContents
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 button issue 2
Disable Clear DContents command in excel - vba code?? 3
Clearing contents 4
.offset() function 1
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
Arrange columns 1
Comparing two columns 7
Paste in column B using Last row of either column B, C or D. 10

Back
Top