Using 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.

Any suggestions would be appreciated.