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").clearcontents
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