vba - code to hide not carry out action if any cell in range is blank

[surkdidat]

Hi all

Firstly thanks for everyones help previously. Greatly appreciated and helps my knowledge no end.

In Range"C16" - if it contains a value i.e. - "XXX" then y screen resizes.

There is code of

Application.ScreenUpdating = TRUE

After this, I do not want anything updated if cells C17:c20 are empty

Once C22 is populated, I want the code to run again

 

[surkdidat]

Firstly, apologies it will not allow me to edit my first post - and I don't think I explained it well!!

Hi

Sorry I don’t think my previous post made much sense!

In cell C16, there is a dropdown menu with various optionsAAA, BBB, CCC, DDD etc

When this is populated it refreshes the worksheet tohide/show certain columns/rows as necessary.

The user has to input data in cells C17:C20 and C22. At themoment the screen refreshes/flashes everytime a user inputs code as at themoment there is the code

Application.ScreenUpdating = True

I know I need to have

Application.ScreenUpdating = False

in thereto stop this.


What I need is my initial code to run (to resize the screenon user input on cell C16, and then to have the screen update set to falseuntil the user has filled in all cells from C17:c22 (cell c21 will alwayscontain data)

Hopefully that makes more sense!!