Is there a way to count the number of cells that have hyperlinks using vba?
i.e. countif(A:A,hyperlinked)
cheers,
nKife
Is there a way to count the number of cells that have hyperlinks using vba?
i.e. countif(A:A,hyperlinked)
cheers,
nKife
![]()
Sub cntLinks() Dim intLinks As Integer intLinks = Range("A:A").Hyperlinks.Count MsgBox intLinks End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks