ExcelBanter - How do I copy a hyperlink in a mailto: to a new cell in Excell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I copy a hyperlink in a mailto: to a new cell in Excell? (https://www.excelbanter.com/excel-discussion-misc-queries/204488-how-do-i-copy-hyperlink-mailto-new-cell-excell.html)

natboyd6

How do I copy a hyperlink in a mailto: to a new cell in Excell?

I am trying to copy from a cell in Excel that has a mailto: hyperlink the
email address only to another cell on the worksheet. Have over 500 cells to
copy and need help with a macro.

All times are GMT +1. The time now is 03:43 AM.