Macro for hide the complete row based on 4 columns value

[Neilesh Kumar]

Dear Experts,

Please find here attached workbook, where i am expecting the macro to hide the complete row if Column H, J, L, & N are 0 by using the formula for a particular row by using the command button for "Hide Blank Rows". But if any of the above said columns any value exist then it won't be hidden by clicking on the command button.

Request to you kindly do help me. Thank you for your precious support and valuable expertise.

Regards,

Neilesh

[davesexcel]

Probably a simple algorithm would do the trick

Please Login or Register  to view this content.

[Neilesh Kumar]

Probably a simple algorithm would do the trick

Please Login or Register  to view this content.

Dear Expert,

Thank you so much for your precious expertise and valuable support. But unfortunately it is hiding the rows upto column N which is mismatching my rest other columns which are upto R. I do have columns upto from H to R (Used Cells are from H9 till R265). I do apologies for the same that i forget to mention that part in my requirement.

Dear Expert, I do have few graphs as well after column R, So is to possible while hiding the rows Graphs will remain at the same place.

So would like to request to you kindly do amend your provided code and resend. Thank you once again for your precious expertise and valuable support.

Regards,

Neilesh

[davesexcel]

You can amend the code yourself to suite your requirements.
Your original question said H,J,L,N. You can delete cells and shift up, I don't believe you can hide cells the same way.

[Neilesh Kumar]

You can amend the code yourself to suite your requirements.

Dear Expert,

I am not so well versed with VBA, So as per the provided all my filled cells details, if you can please do amend at your end and provide the same would be a great help. Thank you once again for your precious support and valuable phase.

Regards,

Neilesh

[Neilesh Kumar]

Probably a simple algorithm would do the trick

Please Login or Register  to view this content.

Thank you so much dear expert. It worked perfectly. Thank you once again for your precious expertise and valuable phase.

Regards,

Neilesh