Remove Blank values

  • Thread starter Thread starter Raghavendra
  • Start date Start date
R

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?
 
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
 
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
Click to expand...

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.
 
Back
Top