I am trying to build a issue tracker template for our IT team. One of the features in this template is, once a user enters a line item, the most recent line item should be e-mailed to the IT team. I am using the code shown below for this purpose
I would like to keep the selection range (columns B thru H and the most recently entered row) dynamic. For this, I am using a variable for the most recently entered row number (which I have stored in cell A2 on the active sheet). However, I cannot get the macro to select the most recent range.
I would appreciate any help you can offer.
Please Login or Register to view this content.