ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Select and delete entire row Excel VBA macro (https://www.excelbanter.com/excel-programming/406684-select-delete-entire-row-excel-vba-macro.html)

RL

Select and delete entire row Excel VBA macro
 
Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?

Don Guillett

Select and delete entire row Excel VBA macro
 
activecell.EntireRow.delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RL" wrote in message
...
Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?



RL

Select and delete entire row Excel VBA macro
 
Blush - tried that with a spelling error
Thanks

"Don Guillett" wrote:

activecell.EntireRow.delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RL" wrote in message
...
Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?





All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com