How to create a conditional command in VBA based on a cell value?

[htawfik]

Hi guys,

I want to hide some rows in a sheet based on the value of a cell in another sheet in the same workbook.

Please help me with the VBA script.

[Izandol]

You may use:

Please Login or Register  to view this content.

or simply:

Please Login or Register  to view this content.

[htawfik]

Thank you,

the only problem it shows an error: "Compile error: invalid outside procedure"

[Izandol]

It must be placed within Sub..End Sub lines - I believed this to be part of a larger routine:

Please Login or Register  to view this content.

[htawfik]

Thank you, that was really helpful

[Izandol]

You are welcome.

Please remember to select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.