| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete columns of a cell range
This has to be dead simple but I can't find the answer in HELP anywhere. In a
macro I have the following code: Range("last.property").Select ActiveCell.Offset(0, -1).Select Range(ActiveCell, "H29").Select SendKeys "^ " 'selects the columns of the cell range Selection.Delete Shift:=xlToLeft What I want to do is delete all the columns from "H" to the one before the column that has the cell "last.property" in it (its column location is variable) The problem is that instead of deleting the columns it deletes only the cell range, I guess because they are still active. How do I get it to select only the columns so that they can be deleted? Thanks and regards, Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS? | Excel Discussion (Misc queries) | |||
| How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Threaded Mode
