Mactro to go through specific range in table and highlight empty cell

  • Hi there,
    I admit I have zero vba experience but have to enhance our expense form at work. Here is what I am trying to achieve with the Macro:
    if employee enters a value in the table column "Amount" And the corresponding cell (same row) in "Description" is left blank then highlight the empty cell and provide message box to indicate to the user that information is missing in that cell/row. Macro to go through the table and check from first row to the last row of the table. This sub is called prior to generating the summary report.
    I need to set it up with specific references to the table (not general to the spread sheet columns) as I have multiple tables on the spread sheet for different types of expenses. I tried different things but nothing is working.

    Thanks for any help!

  • In which columns are the "Amount" and "Description"?

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!