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.