I need to write a macro which will hide all the coulumns with zero values in worksheet.(tab). thanks
H hamad.fatima Feb 22, 2006 #1 I need to write a macro which will hide all the coulumns with zero values in worksheet.(tab). thanks
G Gary''s Student Feb 22, 2006 #2 clarify: Do you want to hide the column if any cell in the column is zero or if all cells in the column are zero.
clarify: Do you want to hide the column if any cell in the column is zero or if all cells in the column are zero.
N NAVEEN Feb 23, 2006 #3 Hi, You can do it without a macro also. Press Ctrl-F to display find dialog and then type 0 and select "Match entire cell contents", then click find all. Now select all results. click on Format menu and Column and then hide. Regards NAVEEN
Hi, You can do it without a macro also. Press Ctrl-F to display find dialog and then type 0 and select "Match entire cell contents", then click find all. Now select all results. click on Format menu and Column and then hide. Regards NAVEEN
