LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frick
 
Posts: n/a
Default Clear"Reset" data input.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable input to populate data fields csinvestor Excel Discussion (Misc queries) 3 September 9th 05 09:00 AM
Need to input data in excel that will print to pre printed sheets Q Setting up and Configuration of Excel 2 June 17th 05 09:06 PM
input text at front of field that contains data Steve M Excel Discussion (Misc queries) 3 May 16th 05 12:28 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"