hyperlink - Check whether a cell contains a link in Excel -
hyperlink - Check whether a cell contains a link in Excel -
i trying check whether values in column, a, contain link, , if true, in column b, want type text, example: link. have many records (10 000), doing hand take lot of time. thx.
here:
sub links() dim lnk hyperlink, lnks hyperlinks set lnks = range("a:a").hyperlinks = 1 lnks.count set lnk = lnks(i) lnk.range.value = "link" next end sub
you need read more on vba if want utilize procedure above. please share research first , @ to the lowest degree code stub. simple hence exception.
excel hyperlink
Comments
Post a Comment