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


LinkWithinBrazilVBAExcelSpecialist

Related Posts Plugin for WordPress, Blogger...