Command Button - Delete Unused Rows

  • Thread starter Thread starter AdmanNJ
  • Start date Start date
A

AdmanNJ

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

--
HTH...

Jim Thomlinson









- Show quoted text -
Click to expand...

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.
 
Back
Top