Reputation: 47
I would like to remove all Underline
in my worksheet and I would like to use a macro for this.
I could only find this code, which adds Underline
.
Worksheets("Sheet1").Activate
ActiveCell.Font.Underline = xlUnderlineStyleSingle
Upvotes: 0
Views: 2238
Reputation: 166825
Like this:
ActiveWorkbook.Worksheets("Sheet1").UsedRange.Font.Underline = False
Upvotes: 5