VBA Code to Clear Formatting from Cells in Excel

by

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

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

Leave a Comment