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

" wrote:

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