Ramneek Sharma - VB From Technical View
MCTS, MCPD, MCT, IBM SQA,Green Belt Six Sigma.
Sunday 16 November 2014
Remove Hyperlinks with Formats from Active Sheet Used Range
Sub RemoveHyperlinks()
ActiveSheet.UsedRange.ClearHyperlinks ' Remove Hyperlinks from Used Range in ActiveSheet
ActiveSheet.UsedRange.ClearFormats ' Remove Formats from Used Range in ActiveSheet
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment