| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Columns Content
Hello, I would like to clear columns on my Excel worksheet using VBA. I tried some simple code and it only deleted some of the columns. Here is what I tried. Range("AF2:BI2").Select Selection.EntireColumn.Delete Thanks for any help you can provide. -- Lizz45ie ------------------------------------------------------------------------ Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410 View this thread: http://www.excelforum.com/showthread...hreadid=481924 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear Columns Content
Range("AF2:BI2").ClearContents
-- HTH RP (remove nothere from the email address if mailing direct) "Lizz45ie" wrote in message ... Hello, I would like to clear columns on my Excel worksheet using VBA. I tried some simple code and it only deleted some of the columns. Here is what I tried. Range("AF2:BI2").Select Selection.EntireColumn.Delete Thanks for any help you can provide. -- Lizz45ie ------------------------------------------------------------------------ Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410 View this thread: http://www.excelforum.com/showthread...hreadid=481924 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear up useless content within worksheet? | Excel Discussion (Misc queries) | |||
| Clear Cell Content Query | Excel Discussion (Misc queries) | |||
| How to clear content from unprotected Field | Excel Worksheet Functions | |||
| Clear Cells Content | Excel Discussion (Misc queries) | |||
| Clear the content of a worksheet using VBA | Excel Programming | |||
![Lizz45ie[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
