VBA code to hide filtered columns (simple table 5 rows / 6 columns wide)

Hi,

I have a simple table in Excel 2010 (5 rows / 6 columns).
I would like the user to be able to filter the table.
After the filter, I would like to hide any columns that only contain (visible) 'N' characters.

I would like to do this in VBA.

Any help much appreciated.
Thank you

Before anyone replies to this, check the cross posts for solutions:

http://www.mrexcel.com/forum/excel-...lumns-simple-table-5-rows-6-columns-wide.html
http://www.excelforum.com/excel-pro...lumns-simple-table-5-rows-6-columns-wide.html
http://forum.chandoo.org/threads/vb...mns-simple-table-5-rows-6-columns-wide.20238/

xx3774, welcome to the forum, but please have a read of this article.