Thread: clear column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default clear column

ws.Columns("A:B").ClearContents
Regards,
Stefi


owl527 ezt *rta:


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.


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=488609