| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Range of Columns
Sub Macro()
Dim lngLastcol as Long lngLastcol = ActiveSheet.Cells.Find(What:="*", _ SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column Range("F1", Cells(1, lngLastcol)).EntireColumn.Delete End Sub If this post helps click Yes --------------- Jacob Skaria "James" wrote: can you please show me how to delete the entire column starting in column f until an empty column is encountered. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete & Merge Columns,Delete Rows with filter, etc | Excel Programming | |||
| create a macro to delete columns and then border remaining columns | Excel Programming | |||
| Delete columns of a cell range | Excel Discussion (Misc queries) | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| Delete Columns For A Range | Excel Programming | |||
Linear Mode
