Another option if you're worried about the user typing formulas into the input
cells.

Select all the cells that can be used for data entry and give it a nice range
name (Insert|name|define).

Then just:

worksheets("inputsheetname").range("inputrng1").cl earcontents

Then you won't have to worry about how the user types his/her entries.

"chryo <" wrote:

Can anyone throw me a bone here.

I need to write some code to attache to a command button that will
check an entire spreadsheet and clear all numeric data. Basically the
spreadsheet is for cost analysis and we enter hours. I want to click
the button and have it clear all the hours from all cells and ignore
any text data.

Any help would be greatly appreciated.

Thanks!

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson