Hello all,
I really hope I can explain myself here: I have this file that I'm working on and need to add a feature in which it takes a fixed cell range, copies it and pastes it in a new outlook email message window. However, I need it to paste the date as an image. I also will need that it eliminates the rows that have no data within that cell range.
For example:
The cell range will be B1:Q29 and sometimes there will be no info in some of the rows like from 10 to 25 (26:29 will always have info). All of these cells have formulas but the cell is blank because that's the return value.
I need a VBA code to make the following: Select the cell range, copy it, delete the empty cells, open a new email message window in Outlook and past it as an image.
Is it possible?
Thank you very much all of you!!
I really hope I can explain myself here: I have this file that I'm working on and need to add a feature in which it takes a fixed cell range, copies it and pastes it in a new outlook email message window. However, I need it to paste the date as an image. I also will need that it eliminates the rows that have no data within that cell range.
For example:
The cell range will be B1:Q29 and sometimes there will be no info in some of the rows like from 10 to 25 (26:29 will always have info). All of these cells have formulas but the cell is blank because that's the return value.
I need a VBA code to make the following: Select the cell range, copy it, delete the empty cells, open a new email message window in Outlook and past it as an image.
Is it possible?
Thank you very much all of you!!
