clearing contents using a "clear" button on the spreadsheet

[dangrats]

Ive sen it done before where you can click a "clear" button on a
spreadsheet to clear data from a select set of cells, rather then
individually clearing them. I know i need to set up a macro but i dont
know how this is all done. Can someone bring some sort of clarity?

thanks

 

[Jan Putcuyps]

Ive sen it done before where you can click a "clear" button on a
spreadsheet to clear data from a select set of cells, rather then
individually clearing them. I know i need to set up a macro but i dont
know how this is all done. Can someone bring some sort of clarity?

thanks

You can put a custom button on your toolbar, and assign a custom command.
If you select properties you can browse through the various commands
available.

Clear cells is situated under "Edit" - "Clear contents"

HTH

Jan

 

[Jan Putcuyps]

You can put a custom button on your toolbar, and assign a custom command.
If you select properties you can browse through the various commands
available.

Clear cells is situated under "Edit" - "Clear contents"

HTH

Jan

Additionally, the VBA command for clear contents should be:

Selection.clearcontents

You can put it in a macro and assign it to your custom button.