| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear column
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear column
hint: this will clear sixth column in active spreadsheet:
Columns(6).ClearContents |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clear cell based on text in opposing column | Excel Worksheet Functions | |||
| Can you clear a column of numbers that contain a formula? | Excel Discussion (Misc queries) | |||
| Clear a column when true | New Users to Excel | |||
| How do I clear a column of data without clearing specific cells? | Excel Discussion (Misc queries) | |||
| How do I clear a column of data without clearing the formulas? | Excel Discussion (Misc queries) | |||
![owl527[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
