software

I need to write a macro which will hide all the coulumns with zero
values in worksheet.(tab).
thanksclarify:

Do you want to hide the column if any cell in the column is zero or if all
cells in the column are zero.
--
Gary''s Studentquot; wrote:

gt; I need to write a macro which will hide all the coulumns with zero
gt; values in worksheet.(tab).
gt; thanks
gt;
gt;

Hi,

You can do it without a macro also. Press Ctrl-F to display find dialog and
then type 0 and select quot;Match entire cell contentsquot;, then click find all. Now
select all results. click on Format menu and Column and then hide.

Regards
NAVEEN

quot; wrote:

gt; I need to write a macro which will hide all the coulumns with zero
gt; values in worksheet.(tab).
gt; thanks
gt;
gt;