Good day,

I would love to understand the difference, other than what is given below, between Address and SubAddress. I notice that Address is normally given as "", why and what else can be put in there? The descriptions are too vague for me.

Please help to clarify.

Regards,
vanhunk

expression .Add(Anchor, Address, SubAddress, ScreenTip, TextToDisplay)

expression A variable that represents a Hyperlinks object.
Parameters
Name
Required/Optional
Data Type
Description
Anchor Required Object The anchor for the hyperlink. Can be either a Range or Shape object.
Address Required
 String The address of the hyperlink.
SubAddress Optional Variant The subaddress of the hyperlink.
ScreenTip Optional Variant The screen tip to be displayed when the mouse pointer is paused over the hyperlink.
TextToDisplay Optional Variant The text to be displayed for the hyperlink.