Hi,
I have made a VBA code that sends out an email with an attachment from Outlook.
I want the code to be applied to a button somewhere at the end of each row. The creating of the email and attachments are working perfectly.
However, my cell references are "fixed" rather than dynamic pr. row. How do I change this - I would rather not copy the code and make x amount of "fixed ranges" .
I hope my question is clear and help is much appreciated.
br,
I have made a VBA code that sends out an email with an attachment from Outlook.
I want the code to be applied to a button somewhere at the end of each row. The creating of the email and attachments are working perfectly.
However, my cell references are "fixed" rather than dynamic pr. row. How do I change this - I would rather not copy the code and make x amount of "fixed ranges" .
I hope my question is clear and help is much appreciated.
br,