How do I insert a button into a spreadsheet that will "clear" all values from
cells that are intended for inputting data, but not clear other cells that
are not meant for data input? As part of this I suppose I need some way to
designate which cells are meant for data input and which ones are not.
Thanks, MichaelZ

Simplest way. Hold down the control key while selecting each cell you want
to cleargoto the namebox just to the left of the formula box and type in
rngtoclearfire this macro assigned to a shape or forms button.

Sub clearcells()
Range("rngtoclear").ClearContents
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelZ" wrote in message
...
How do I insert a button into a spreadsheet that will "clear" all values
from
cells that are intended for inputting data, but not clear other cells that
are not meant for data input? As part of this I suppose I need some way
to
designate which cells are meant for data input and which ones are not.
Thanks, MichaelZ

Ran into a little problem...
Some of the input cells were merged cells, so an error message reading,
"Cannot change part of a merged cell" was generated. Is there any way around
this? I still want to be able to clear the input cells, even if they are
merged cells.
Thanks.

"Don Guillett" wrote:

Simplest way. Hold down the control key while selecting each cell you want
to cleargoto the namebox just to the left of the formula box and type in
rngtoclearfire this macro assigned to a shape or forms button.

Sub clearcells()
Range("rngtoclear").ClearContents
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelZ" wrote in message
...
How do I insert a button into a spreadsheet that will "clear" all values
from
cells that are intended for inputting data, but not clear other cells that
are not meant for data input? As part of this I suppose I need some way
to
designate which cells are meant for data input and which ones are not.
Thanks, MichaelZ

.

In the defined name, you will have to specifically reference the merged
cells as shown here. g9 not merged.
=Sheet28!$G$7:$H$7,Sheet28!$G$9,Sheet28!$G$11:$H$1 1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelZ" wrote in message
...
Ran into a little problem...
Some of the input cells were merged cells, so an error message reading,
"Cannot change part of a merged cell" was generated. Is there any way
around
this? I still want to be able to clear the input cells, even if they are
merged cells.
Thanks.

"Don Guillett" wrote:

Simplest way. Hold down the control key while selecting each cell you
want
to cleargoto the namebox just to the left of the formula box and type in
rngtoclearfire this macro assigned to a shape or forms button.

Sub clearcells()
Range("rngtoclear").ClearContents
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelZ" wrote in message
...
How do I insert a button into a spreadsheet that will "clear" all
values
from
cells that are intended for inputting data, but not clear other cells
that
are not meant for data input? As part of this I suppose I need some
way
to
designate which cells are meant for data input and which ones are not.
Thanks, MichaelZ

.

Thanks Don. This works great.
Michael

"MichaelZ" wrote:

How do I insert a button into a spreadsheet that will "clear" all values from
cells that are intended for inputting data, but not clear other cells that
are not meant for data input? As part of this I suppose I need some way to
designate which cells are meant for data input and which ones are not.
Thanks, MichaelZ