PDA

View Full Version : hide/unhide column after criteria match



amartakale
09-06-2019, 01:11 AM
Dear Sir,

Can we hide/unhide column with help of VBA code.

If I select MOSL in cell E3 & Click Hide button then all column where found MOSL text that all column will be hide & if click unhide button that all column will be unhide. Same process for all companies.

Regards
Amar

p45cal
09-06-2019, 02:43 AM
Attached.

amartakale
09-06-2019, 03:24 AM
Dear p45cal,

Its work perfect.

Can we collect all column of MOSL as group. Means If I select MOSL in cell E3 then all MOSL text column group side by side & others remaining column will be hide.

24946
Regards
Amar

p45cal
09-06-2019, 03:52 AM
Attached.

amartakale
09-06-2019, 05:04 AM
Mind blowing:clap::clap:

Thanks very much Sir, Perfect:yes