Urgent reply would be a great help
 

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

Urgent reply would be a great help
 

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.
--
Gary''s Student


" wrote:

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

Urgent reply would be a great help
 

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