VBA Code:
' VBA Code to Clear Formatting from Cells in Excel
' This code clears formatting from a specified range of cells
Sub ClearFormatting()
Dim rng As Range
' Set the range of cells to clear formatting
Set rng = Range("A1:B10") ' Replace with your range
' Clear formatting from the range of cells
rng.ClearFormats
' Optional: Clear other formatting attributes
rng.Font.Bold = False
rng.Font.Italic = False
rng.Font.Underline = xlUnderlineStyleNone
rng.Font.ColorIndex = xlColorIndexAutomatic
' Optional: Clear cell contents
rng.ClearContents
' Optional: Clear borders
rng.Borders.LineStyle = xlLineStyleNone
' Optional: Clear conditional formatting
rng.FormatConditions.Delete
' Optional: Clear number formatting
rng.NumberFormat = "General"
' Optional: Display a message box when formatting is cleared
MsgBox "Formatting has been cleared from the range of cells."
End Sub
Join Our Telegram Group
Join Our WhatsApp Group
