I have a macro that runs based on a row and column range, for example the macro occurs if someone selects a cell in column 5-8 and row 3-48. However, these cells are in a table called "Tbl_Results" and as users may want to extend the number of rows in the table, so I would like this macro to extend as well. With the current code, even by added a row in the table, the macro stops at row 48. How would I indicate the number of rows to encompass all rows in "Tbl_Results"? I don't believe the column numbers will be changing.
Currently, it is written as:
If Target.Column >= 5 And Target.Column <= 8 And Target.Row >= 3 And Target.Row <= 48
Thank you.
Currently, it is written as:
If Target.Column >= 5 And Target.Column <= 8 And Target.Row >= 3 And Target.Row <= 48
Thank you.