Hello.

I created a Macro tied to a button that will add a new row to the table where the button is located. In the final column of each row, there is a dropdown menu to select the status of ordered parts (Ordered, Received, Null). By default, I would like each newly entered row to default to "Null" on column F. However, each new row is automatically blank (although formatting and the dropdown do transpose perfectly).

Here is my code:

Please Login or Register  to view this content.
I know I need to place something in there to either grab the cell in column F to enter "Null", or perhaps I need to think about it a different way.
Also, please note that this worksheet has multiple tables, each with their own "Add Row" button.