Clear"Reset" data input.

F

Frick

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.
 
R

Ron de Bruin

hi Frick

Code looks like this

Rows("19:100").Clear

Next time post in the programming group
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top