Command Button - Delete Unused Rows

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!
 
G

Guest

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

AdmanNJ

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.
 

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

Similar Threads

Access Automatically Send a notification email once a record is added 0
Excel Populate Delivery Note 0
Word VBA for deleting Selected Row 0
Delete rows in a sequence 9
Protect Sheet not allowing insert or delete rows. VBA buttons notsolving problem ? 1
Refreshing Data loses subtotals 3
Outlook custom forms 0
VBA just dies - EXCEL 97 6

Top