| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to erase a column VBA
Hi,
Im trying to erase a column via VBA, this column is variable and depends on the active cell, Im trying this but obviously its not working: ActiveSheet.Columns(ActiveCell).Delete Any kinda help will be very appreciated Thx Jepane |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to erase a column VBA
Sub demo()
ActiveCell.EntireColumn.Delete End Sub -- Gary''s Student - gsnu200734 "Jepane" wrote: Hi, Im trying to erase a column via VBA, this column is variable and depends on the active cell, Im trying this but obviously its not working: ActiveSheet.Columns(ActiveCell).Delete Any kinda help will be very appreciated Thx Jepane |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to erase a column VBA
Thanx a lot Gary, i guess it was trivial, but helps me a lot
"Gary''s Student" wrote: Sub demo() ActiveCell.EntireColumn.Delete End Sub -- Gary''s Student - gsnu200734 "Jepane" wrote: Hi, Im trying to erase a column via VBA, this column is variable and depends on the active cell, Im trying this but obviously its not working: ActiveSheet.Columns(ActiveCell).Delete Any kinda help will be very appreciated Thx Jepane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Erase duplicate rows | Excel Discussion (Misc queries) | |||
| Erase Key in Legend | Charts and Charting in Excel | |||
| I want to relocate a column, save the figures, and erase formula | Excel Worksheet Functions | |||
| Erase Duplicates | Excel Worksheet Functions | |||
| How can I erase all but every 87th row in Excell? | Excel Worksheet Functions | |||
Hybrid Mode
