cells.delete

[lezawang]

Hi
I was doing cells.clear then I thought of doing cells.delete. To my surprise, when I click on a button to run the code below, everything got deleted including the button. So I left with a clean sheet. What I thought would happen is that the who sheet will get deleted and also why the control button got deleted since it is not part of any cell? Thank you so much.

Sub deleteall()
    Cells(1, 1).Delete
End Sub

 

[Fluff]

That code does not delete everything, it deletes A1 & shifts the below up 1 row

 

[lezawang]

sorry wrong code I paste. so sorry

Sub deleteall()
    Cells.Delete
End Sub

 

[Fluff]

Whilst deletes all cells, it doesn't delete any buttons.
What type of buttons are you using? Form controls or ActiveX?

 

[lezawang]

Form Control

 

[Fluff]

If I put a FormControls Button, from the Developer tab on the sheet, it does not get deleted.

 

[MARK858]

If I put a FormControls Button, from the Developer tab on the sheet, it does not get deleted.

It does get deleted for me using 2010, ActiveX buttons aren't getting deleted (disappearing from the Find-Selection pane as well so pretty sure it is actually deleted).


Edit: a bit strange as a button is getting deleted but a group box isn't

 

[Fluff]

With 2013 no controls get delete, but shapes do.

 

[lezawang]

I am using office 365. Developer-->Insert-->Form control-->Button
and it get deleted when I click on it to run that macro. Thank you.