alienscript
10-25-2009, 10:28 AM
Hi VBA expert community!
I am looking for some help on hiding columns with the result from autofilter. I have no experience in coding with autofilter result.
After I applied autofilter in column 1, I need the code that would hide the entirecolumn when there are no number (or is blank, or sum is zero) in the visible cells of each range of column.
The original data is in sheet1 and the result that I want in the 2nd sheet. I am using Excel 2003.
Many thanks!
I am looking for some help on hiding columns with the result from autofilter. I have no experience in coding with autofilter result.
After I applied autofilter in column 1, I need the code that would hide the entirecolumn when there are no number (or is blank, or sum is zero) in the visible cells of each range of column.
The original data is in sheet1 and the result that I want in the 2nd sheet. I am using Excel 2003.
Many thanks!