I have a worksheet that is called Main. On this worksheet I have variuos
cells where I input data. I would like to create a Button called "Clear
Sheet" which will remove all the input data on the sheet from A1:K12, but
not any of the cells that have formula.

It should also be noted that I have a Button called "Add Rows" which adds
one row and copies all the cells in the preceding row from Col B through K
each time it is clicked beginning in row 19. All these rows that are
created have some input and some formula. And, each added row has a border
around each cell in Col B through K. I add this information because I would
like the Clear Sheet button to remove all rows from row 19 to end clearing
not only all the data input in these rows but also all the formulas and cell
borders. You might think it would be just as easy to set this area to just
delete the rows, but this can't be done because another sheet picks up
information in these rows if it exists. If I delete these rows I would then
get an error message on the other sheet.

Thanks for any help offered.

hi Frick

Code looks like this

Rows("19:100").Clear

Next time post in the programming group

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frick" wrote in message ...
I have a worksheet that is called Main. On this worksheet I have variuos cells where I input data. I would like to create a
Button called "Clear Sheet" which will remove all the input data on the sheet from A1:K12, but not any of the cells that have
formula.

It should also be noted that I have a Button called "Add Rows" which adds one row and copies all the cells in the preceding row
from Col B through K each time it is clicked beginning in row 19. All these rows that are created have some input and some
formula. And, each added row has a border around each cell in Col B through K. I add this information because I would like the
Clear Sheet button to remove all rows from row 19 to end clearing not only all the data input in these rows but also all the
formulas and cell borders. You might think it would be just as easy to set this area to just delete the rows, but this can't be
done because another sheet picks up information in these rows if it exists. If I delete these rows I would then get an error
message on the other sheet.

Thanks for any help offered.