Hello,
I am looking for some help with copying range A:F from the active row based on the formulas in the beginning of the code, then paste it into the email body later in the code. What I have cobbled together works exceptionally well, but I need to replace "INSERT A:F HERE!" with actual data.
Thank you in advance.
Please Login or Register to view this content.
Will it be A:F in the same row as Cell?
How do you want to display the range in the email?
If posting code please use code tags, see here.
Yes, if the cell colorIndex =45
Thanks for the quick response Norie.
If the active row range could appear as an exact copy as it is on the spreadsheet would be sufficient.
I don't necessarily need anything fancy.
I wasn't really suggesting anything fancy.
To get it to appear like it is on the sheet you would need to use HTML.
If you just wanted it to appear as a list of values you could use this.
Please Login or Register to view this content.
I'll give this a try.
Thanks so much.
The code works as advertised. Thank you so much. One last question; how difficult would it be to have the vb look at M of the active row at the beginning and if populated, move on and disregard the L & email?
It would be straightforward to look at M but what do you mean by 'the L & email'?
Do you mean you want to check column M before you check column L?
Perhaps something like this.
Please Login or Register to view this content.
YES! That's it.
Thank you so much for the quick resolution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks