Select all your input cells
Then type a nice name in the namebox (to the left of the formulabar)
(I used InputRng.)

Then you could add a button to clear all those cells that you just named:

option explicit
sub testme()
worksheets("sheet1").range("InputRng").clearconten ts
end sub

If you change the input cells (add more???), just delete the name
(insert|name|define dialog) and then recreate the same name.

Jonibenj wrote:

I have a worksheet set up where users can enter data to get results.
How do I set up a button to click which will clear all the input
cells?

Jonathan

--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048
View this thread: http://www.excelforum.com/showthread...hreadid=470075

--

Dave Peterson