Address Property Example

This example sets the address of the specified hyperlink.

Spreadsheet1.Range("a22").Hyperlink.Address = "http://www.microsoft.com"

This example returns the address of the visible range.

MsgBox Spreadsheet1.ActiveSheet.VisibleRange.Address