I have a VBA code that attaches my active sheet to an outgoing email. I would like to add the data from the last cell containing data in the 10th column of the active sheet into the body of the email. For example, on one sheet that may be HL926 but on the next it may be HN927. It is always the bottom most cell containing data in the 10th column.
How can I reference this in the code?
How can I reference this in the code?