How do I call a cell by its defined name?

AFGPHXExcel
AFGPHXExcel used Ask the Experts™
on
I have a cell defined as Rd_Reviewer1ReqBy_Email. It contains an email address and I am looking to use the .sendmail function of Excel VBA. I am trying to reference the cell by its defined name. How would I do that?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Range("myrange")

Ng,
Excellent information on sending mail via VBA (http://www.rondebruin.nl/sendmail.htm)

NG,

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial