Hide/Unhide columns based on the value of the cell help!

Hi,
I want to hide/unhide columns for different standard divisions. The code is not giving error but not performing the action require. The divisions are from ‘A to j’ and the hide/unhide columns varies from division to division.

Please suggest me a correction in the code.

Thanking you.

is something wrong with your attachment. please check

you have to put your code in sheet Information module, not in sheet1 module

Hi patel45,
Thank you. Now I have inserted the code in the sheet module of information sheet. It's working fine without error but no any action of hiding the columns on sheet1 range 'g:r and t:z'.

If the value in cell 'b1' information sheet changes then I have to hide different columns as per the division . It varies from division to division.

Please see the modified file.

Thank you.

Hi venkat1926,
Thank you for suggestion. I have changed the file. Please see the code and suggest me a solution why it's not performing the action of hiding the columns on sheet1.

Thank you.

I'm sorry, but i can not understand your code and your goal

At present I hide the columns manually after changing the value in cell $b$1 on the information sheet. The goal of this code is to perform this action immediately after changing the value in cell $b$1 on sheet information automatically and save time and manual work.
I want to hide the columns range 'g:r and t:z' if the cell on information sheet cell $b$1 contains a text 'Std. 9 A'. Likewise if the cell $b$1 on information sheet contains a text 'Std 9 B' then hide columns range 'aa:ap' and so on till he last division 'J'. The hiding columns varies from division to division.

Just suggest me a code for Std 9 A and Std. 9 B. I will do the rest divisions.

I want to perform the action immediately after changing value in cell $b$1 on information sheet.

hope this much clearification will help you to modify the code to meet my requirement.

Thanking you.

Hi, mso3,

maybe try

Please Login or Register  to view this content.

Code goes behind sheet Information.

Ciao,
Hoilger

Hi Holger,

Good morning!

Excellent! It's working absolutely fine as per my requirement.

I appreciate you for the kind help to meet my requirement to complete my project.

Thank you and have a nice day.