View Single Post
 
Old 02-11-2019, 06:49 AM
aaghd72 aaghd72 is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2019
Posts: 15
aaghd72 is on a distinguished road
Question Design Macro or Code to Delete Table Rows When Null/Blank/Empty Upon Doc Close/Save

The same document that I used your suggestions yesterday to number page 3 when it existed, I now would like to know how to delete rows of a table that are not used. The user will enter data in a "MacroButton Field" box and the data will be entered into a row 1. The next "MacroButton Field" will enter data into row 2 and so forth and so forth. In all there are 20 rows in the table. If the user uses 5 rows or 18 rows, I would like them to be able to run a macro to delete the empty rows or have the macro run when they print or save perhaps so it is completed automatically. One of my issues is that each row has the "MacroButton Field text: "Click here to enter first item." Thanks in advance for your assistance.

Last edited by aaghd72; 02-11-2019 at 10:20 AM. Reason: Added pertinent information.
Reply With Quote