| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete row where active cell is located using VBA
Hi
Is there a way to delete the row where the active cell is on using VBA ? Thanks for any help in advance. Jeff |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete row where active cell is located using VBA
ActiveCell.EntireRow.Delete
For more on deleting rows, see www.rubbershoe.com/deleterows.htm "Jeff Marshall" wrote in message ... Hi Is there a way to delete the row where the active cell is on using VBA ? Thanks for any help in advance. Jeff |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete row where active cell is located using VBA
activecell.entirerow.delete
-- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Jeff Marshall" wrote in message ... Hi Is there a way to delete the row where the active cell is on using VBA ? Thanks for any help in advance. Jeff |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete row where active cell is located using VBA
Perfect !!
Thanks Jeff "Robin Hammond" wrote in message ... activecell.entirerow.delete -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Jeff Marshall" wrote in message ... Hi Is there a way to delete the row where the active cell is on using VBA ? Thanks for any help in advance. Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Find last cell in a column, Delete its contents and make it active | Excel Worksheet Functions | |||
| Delete multiple rows where a blank cell is located | Excel Discussion (Misc queries) | |||
| How do I move cursor in an active cell without using delete/backsp | Excel Discussion (Misc queries) | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
Linear Mode
