Clear Excel sheet format

Help Activities
, ,
1

Hello,

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

2

Hi
Did we try with this activity

Cheers @nidhi.kowalli

3

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)

4

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

5

Hi @nidhi.kowalli

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

image
image1365×572 53 KB

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

In your case
Clear Format= True

Hope this helps

Regards
Sudharsan

6

@Sudharsan_Ka
Thanks a lot!!

Cheers! that worked!

Regards,
Nidhi K

7

That’s Great

Happy Automation @nidhi.kowalli

Regards
Sudharsan

8

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