VBA Macros to delete blank

[hecgroups]

Hello,

I am looking for VBA MAcros to clear contents of cells which having a formula with blank output. Every time i have to do this manually which becoming a headache for me every week.

I have 13 columns and everytime i have to use filter and select the blank cells and right click clear content. This procedure i have to 13 times. Every week the values is changing.

Cany anyone help me to solve this issue.

[tom1977]

Hi select your range and run this
check this on the copy of your file

Sub aa()
Dim c As Range
For Each c In Selection
    If c.Value = "" Then
    c.ClearContents
    End If
    
    Next
    
End Sub

[hecgroups]

Tom you make my life thanks for our valuable script. IT works.

[hecgroups]

hai tom thanks for respond but i am afraid that this will not clear the cells which is having values. Can you tell me this will clear the cells which is having zero output formula.

[tom1977]

Please tell me: You want to clear the cells which have formula inside but the result of this formula is null string "" or what? Maybe I misunderstood You.

ok no problem

[hecgroups]

U understand very well thanks it works for me.