Email fixed and user selected range to email.

[Barking_Mad]

Hi,

I have used the following Ron de Bruin macro to allow me to send a selection of cells to email, and send the email.

What I’d really like it to do however is to include the header columns I have set-up as well as the ones selected by the user. The header column cells are from B4:M4. I can see the annotations to allow me to set a fixed range, but not sure how to get both working at once? Any help appreciated.

Please Login or Register  to view this content.

[Barking_Mad]

*bump* any help appreciated.

[Barking_Mad]

anyone? Help much appreciated

[john55]

a very useful code, the author is Leith Ross, see if it helps you!

[Barking_Mad]

a very useful code, the author is Leith Ross, see if it helps you!

Hi John,

Thanks, it's really nice but its not picking up the cells I select when pasting into the email, just the whole of the range. Ideally id like it to paste the top header row (B8:L8) plus the row that the user selects. Any suggestions?

[john55]

just change the range to "b8:l8" and then copy/paste the rows, but I am not sure it'll look like as a "normal" table. good luck!