delete entire row(s) based on a selection

[robertvdb]

I have this sheet where I select one or more cells. When I press the commandbutton, I want the entire rows of the selection to be deleted.

Can anyone help ?

See image. Thanks.

 

[sg2209]

Hi Robert,

Quick question please, are you doing to select this manually or do you have some kind of VBA Code already that slects and then next step would be deletion.

 

[mumps]

Try:

Sub deleteRows()
    Selection.Rows.EntireRow.Delete
End Sub

 

[robertvdb]

Hi Robert,

Quick question please, are you doing to select this manually or do you have some kind of VBA Code already that slects and then next step would be deletion.

manual selection

 

[sg2209]

I guess @mumps has given you what you are looking for

 

[robertvdb]

I guess @mumps has given you what you are looking for

yes indeed !

 

[robertvdb]

Try:

Sub deleteRows()
    Selection.Rows.EntireRow.Delete
End Sub

Thanks Mumps !

 

[mumps]

You are very welcome.