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?