Macro for Hide & Unhide the rows upto a certain column

Dear Experts,

Please find here attached sample workbook, Where row 11 & 12 are with 0 Values for column H, J, N, & P and i am looking for the macro to hide the rows with 0 Values and i do have tables in Column S to Column BN which i do not want to hide them.

I want to hide the rows only from Column A to Column P. Request to you kindly do provide your precious expertise.

Many thanks and kind regards,

Neilesh

Dear Expert,

Is it not possible to hide the rows upto certain column ie. column P

Originally Posted by davesexcel

Try it out, see if you can do it.

Dear Expert,

I do not have anything to try as of now. If you have can you please provide the macro.

Many thanks and kind regards,

Neilesh

Dear Expert,

Thank you for you precious support and valuable phase.

Many thanks and kind regards,

Neilesh

Dear Expert,

Is it possible to use the macros for Cell Up and Cell Down from column B to P for 0 Values, instead of using macro for hiding the complete row.

Originally Posted by davesexcel

It's not a macro issue is a physicality issue. You can't hide part of a row. How can you have A10 hidden, but B10 showing?

Dear Expert,

Is it possible to use the macros for Cell Up and Cell Down from column B to P for 0 Values, instead of using macro for hiding the complete row.

Originally Posted by davesexcel

This will delete cells that are blank in B:P

Please Login or Register  to view this content.

Thank you so much Dear Expert, worked like a charm. Once again thanks a ton for your precious phase and valuable support.

Many thanks and kind regards,


Neilesh