Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variable input to populate data fields | Excel Discussion (Misc queries) | |||
Need to input data in excel that will print to pre printed sheets | Setting up and Configuration of Excel | |||
input text at front of field that contains data | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |