VBA Macros to delete blank

**hecgroups** · 03-01-2012, 03:21 AM

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** · 03-01-2012, 03:47 AM

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

Please Login or Register  to view this content.

**hecgroups** · 03-01-2012, 09:33 AM

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.

**hecgroups** · 03-01-2012, 09:44 AM

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

**tom1977** · 03-01-2012, 09:45 AM

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