| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete row or col
I need macro to delete entire row or col
I really appreciate your help! Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete row or col
Hi gv
The macro recorder could also help you achieve this. Here's a sample code: Rows("2:2").EntireRow.Delete Columns("B:B").EntireColumn.Delete HTH Cordially Pascal "gv" a écrit dans le message de ... I need macro to delete entire row or col I really appreciate your help! Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete row or col
"EntireRow" and EntireColumn" are superfluous; e.g., Rows("2:2") already
refers to the entire row. Where it would be useful is, e.g., Rows("A2").EntireRow.Delete Alan Beban papou wrote: Hi gv The macro recorder could also help you achieve this. Here's a sample code: Rows("2:2").EntireRow.Delete Columns("B:B").EntireColumn.Delete HTH Cordially Pascal "gv" a écrit dans le message de ... I need macro to delete entire row or col I really appreciate your help! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Linear Mode
