Views

Histats

Vitrine

Excel Macro - Removendo hiperlinks - Remove Hyperlinks

Inline image 1


Selecione o bloco de células alvo e elimine todos os hiperlinks (WWW, e-mail, etc). Estes serão removidos, deixando os dados intactos.
Sub Remove_Hyperlinks()
If TypeName(Selection) <> "Range" Then Exit Sub
Let Application.ScreenUpdating = False

Selection.Hyperlinks.Delete

Let Application.ScreenUpdating = True
End Sub



TagsMacros, Excel, hyperlink, remove



✔ VBA Brazil®

✔ VBA Brazil®
brazilsalesforceeffectiveness@gmail.com
Related Posts Plugin for WordPress, Blogger...
diHITT - Notícias