VBA Code to clear content, Formats, Hyperlink and Comment

C K Mehta Saturday, September 26, 2020 0

VBA Code to clear content, Formats, Hyperlink & Comment

VBA

Selection.Clear

Range("A1:A2").Selection.ClearFormats

Range("A5:A6").ClearContents

Range("A9:A10").ClearHyperlinks

Range("A9").ClearHyperlinks

Range("A910").ClearComments

No comments

Subscribe to: Post Comments ( Atom )

real time web analytics

View My Stats