sub commandbutton1_click()
Range("A1:F50").ClearContents
end sub
edit to your data.

Regards
FSt1

"Fraelorn" wrote:

Could anyone suggest a simple layout of code required to setup a Command
Button that will clear a range of fields?

Thanks in advance.