VBA Multiple IF

Hello guys,

I have some trouble with the if function on VBA.

I Want to hide rows and columns if one cell is =0.

The code to hide the rows and columns works separately.

But when both are actives its like they are on the same loop. If k7 is not =0 but c19 is, the columns will not be hidden and vice versa.

Apparently both condition must be validated to run. But it's not supposed to... I want each if loop to run independently.

Thanks

Hello,

Thanks for the help. But it runs only If I select the cell and update their content. I want it to do it automatically if these cell contain a 0.

These cell are Vlookup values.

See attached my excel file.

Basicaly I am using Vlook up values to feed the form. I want some row and column to be automatically hidden if these cells =0.

The only cell the user is allowed to change is F4.

Yes, I have an error on :Select Case Target.Address...

Hi,

Thanks for your help:

It works for k7, but when the cell has a value, it doesnt unhide the column.

When c19 =0 I have the follwing error on: EntireRow.Hidden = Range("c19").Value = 0

And that makes excel to crash... I have to use the task manager to close the program