 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Command Button - Delete Unused Rows
I'd like to create a COMMAND BUTTON that would delete any unused rows in an order form I've created. The Excel sheet is locked/protected, so end-users cannot edit or delete any content. I'd like them to be able to select the COMMAND BUTTON to remove any unused rows to make printing and viewing easier. Any guidance is appreciated. Thanks! Define unused. Unused could mean that there are formulas in the cells returning blank characters. It could mean blank rows/columns sandwiched in the middle fo the sheet. It could be that the used range is larger than the size of the data filled cells in the sheet...  SignatureHTH... Jim Thomlinson > I'd like to create a COMMAND BUTTON that would delete any unused rows > in an order form I've created. [quoted text clipped - 8 lines] > > Thanks! On Aug 3, 5:24 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com> wrote: > Define unused. Unused could mean that there are formulas in the cells > returning blank characters. It could mean blank rows/columns sandwiched in [quoted text clipped - 20 lines] > > - Show quoted text - Jim ... Basically, I created an "order form" with 10 columns (Qty, Description, Price, etc.) and about 30 rows to allow orders with multiple line items. Many times, however, orders come in with less than 30 lines. I'd like end-users to be able to remove those lines that have nothing entered. Does that make sense? Thanks for your help. I found this yesterday whilst looking for something else on forms. Might be useful to you Regards DonH http://exceltips.net/idx/9/114/Macros_and_VBA/article/Deleting_All_Empty_Rows.html > I'd like to create a COMMAND BUTTON that would delete any unused rows > in an order form I've created. [quoted text clipped - 8 lines] > > Thanks! > I found this yesterday whilst looking for something else on forms. > Might be useful to you [quoted text clipped - 19 lines] > > - Show quoted text - Thanks Don. I appreciate your help. -a- Hi AdmanNJ Check out http://www.rondebruin.nl/delete.htm SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > I'd like to create a COMMAND BUTTON that would delete any unused rows > in an order form I've created. [quoted text clipped - 8 lines] > > Thanks! > Hi AdmanNJ > [quoted text clipped - 18 lines] > > - Show quoted text - Thanks Ron. I will check out your link. Appreciate the help.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.