Reference>IXLSHyperLinks>Count

Returns the number of hyperlinks in a IXLSHyperlinks collection. Read only Integer.

Syntax

property Count: integer;

This example displays the number of hyperlinks on worksheet one.

MessageDlg(inttostr(WorkBook.Sheets[1].Hyperlinks.Count) + ' hyperlinks on worksheet one.',
           mtInformation, [mbOk], 0);

This example displays the number of hyperlinks on range A1:D10.

MessageDlg(inttostr(WorkBook.Sheets[1].Range['A1','D10'].Hyperlinks.Count) + ' hyperlinks on A1:D10.',
           mtInformation, [mbOk], 0);