Clear Excel sheet format

Hello,

How can I clear the whole ‘Macro Enabled excel sheet’ Format?

Hi
Did we try with this activity

Cheers @nidhi.kowalli

Hi,

You can achieve this through VBA code.

Public Function RemoveFormattingEmptyCells()

  Dim sheet As Worksheet
  Application.Calculation = xlCalculationManual
  Application.ScreenUpdating = False
  
	Worksheets("Data").Activate
    ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).ClearFormats

  Application.Calculation = xlCalculationAutomatic
  Application.ScreenUpdating = True

End Function

InvokeVBA3.zip (9.3 KB)

@Palaniyappan
I don’t want Data to be cleared.
I want only format to be cleared!

Hi @nidhi.kowalli

You can try with the "Clear "Activity in the EasyExcel Package

Input Options
You need to give Boolean values as per your requirements

In your case
Clear Format= True

Hope this helps

Regards
Sudharsan

@Sudharsan_AIT
Thanks a lot!!

Cheers! that worked!

Regards,
Nidhi K

That’s Great

Happy Automation @nidhi.kowalli

Regards
Sudharsan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.