Delete all cells on a sheet?

[TaviO!]

Hey all =D
First of all, I'm sorry for asking how to solve a whole problem, instead for asking for help on a specific thing. I would try and solve this on my own, but I know nothing about VBA and am totally out of time (and need to deliver this soon).
I intend to find tutorials on the internet and learn how to deal with excel on my own. However, like I said, I have no time for this right now.
What I need to do is, I believe, very simple.
I want to put a button on my sheet that calls a function that will clear every cell on the sheet, except for those cells that have text and formulas in it.
I already know where to write the macros and stuff like that, all I need is the code.
Any help will be appreciated. If you guys give me the whole code, I be able to understand it, like, how to iterate through all cells in a sheet, how to check their content, etc. However, if you prefer to indicate me where I can read about these concepts, the result will be the same.
Thanks a lot!!!

[royUK]

What do the cells to delete contain?

What you need to do is protect & lock all the formula cells, and text if you don't want the user to change it. Then you can clear all unlocked cells.

[TaviO!]

The cells I want to delete contain numbers only.
Very good idea, will do that now.
Thanx!

Edit:
Well, it doesn't seem to solve my problems.
I locked the cells I don't want to delete and then proceeded to delete all cells, hoping it would delete everything that wasn't blocked. But, all it does is display a message warning me that the cells are blocked and quit the process.

[davesexcel]

Try this

Please Login or Register  to view this content.

[TaviO!]

Worked perfectly. Thanks a lot you all!
Close topic