Mark Kennedy wrote:
no email addresses are
initially entered, just a formula, say "+r5*.05".....it places the
value in the dcell, but it makes it a hyprtlink to an email.


OK another possibility would be:
- a Worksheet_Change or Workbook_SheetChange event procedure is
creating the hyperlink after you enter the data.

It is probably irrelevant but most people enter formulas by starting
with = rather than with +.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup