Hello, I have put together a database program where a user imports several excel files, then clicks a button to extract several cells to a new sheet within the workbook that is then emailed. All of this is done by clicking three buttons on the top of one of the sheets. My problem lies in emailing the new sheet as it will be named something different everytime it is created. What I need help with is how do I get the code below to email the sheet that has just been created when there may be several sheets in the workbook? Would it be easier to modify the macro that creates the new sheet, then adds the control button and assigns it to the correct macro?
I am using the code below to email the active sheet.
This is the code I am using to create the new sheet.
Bookmarks