When the Date value in cell B2 is changed, I would like the Delete_Table_Rows macro (see below) to run prior to the rest of the code contained in the Worksheet_Change code (also below). This macro should only run if there is data in the 38th row and beyond (39, 40, 41, etc.). This is necessary in order to avoid having the macro throw an error. Please note that I am referring to table row and not worksheet row. I tried adding a Call Delete_Table_Rows line somewhere in the Change code but haven’t been successful. It seems perhaps something else must be written with it to allow this to be compatible. Please help!
My goal is to have this table be able to reset itself and accept new data. I somehow will need to find a way to clear out the C2:C38 cells as well but, at the moment, am satisfied with doing so manually.
Bookmarks