Remove Blank values

[Raghavendra]

Hello Techies,

I am very new to Excel VBA programming.

I would like to write a macro for drawing a Pivot Table based on a
selected data.

The selected data might also contain Blank/Null values.

Now my question is how do I remove those NULL values.

Testdata

Count a b c
IAT1
IAT2 1


As you can see in the testdata above, the columns 'a' and 'b' doesnot
contain any value. I would like to remove those columns.

Is there any way how can filter it?

 

[Javed]

Do you want to delete the columns if it contains only blank/null
or
Do you want to delete the contents only if it contains only blank/
null

 

[Raghavendra]

Do you want to delete the columns if it contains only blank/null
or
Do you want to delete the contents only if it contains only blank/
null

Hello Javed,

Thanks for the reply.

I would like to delete the columns if it contains only blank/null.

Any help would be very greatly appreciated.