delete button

[bossierben]

Using excel 2007, I need to create a button, that will DELETE all data in my worksheet called "Orders" between cells Y13 and AD40 and then have it take me to worksheet called "Andersen"

 

[rjwebgraphix]

Very basic easy way to do it....

Sub clearrng()

Sheets("Orders").Range("Y13:AD40").ClearContents
Sheets("Andersen").Activate

End Sub

 

[JoeMo]

Using excel 2007, I need to create a button, that will DELETE all data in my worksheet called "Orders" between cells Y13 and AD40 and then have it take me to worksheet called "Andersen"

You can assign this code to a forms control command button.

Sub bossierben()
Sheets("Orders").Range("Y13:AD40").ClearContents
Sheets("Andersen").Select
End Sub