Hello everyone,
I apologize if this has already been addressed in another thread but, I wasn't able to find it.

I am trying to create a macro to copy cells B5:B10, B12, and B15. B10 may have an n/a return depending on other info on the worksheet. Once it is copied, I will be using this to create an email (using vba) to send from outlook.

I would appreciate any help anyone is able to provide, even if it's a "nope, can't do that" response.

Thanks!