Hyperlink via code
I have a column in a worksheet which contains details of a person and a 6 or
4 figure number.
I need to extract the number for the email address in the mailto part of a
Hyperlink, and use the data in another cell in the same row as the subject.
I can extract the number using code and use mailto in a Hyperlink formula,
but I can't seem to be able to do both.
|