Un-hide Columns based on a cell value

I have a large worksheet with Hidden Columns that I need to UnHide when any cell in a particular range = 1.

If any Cell in Range "BF9:BF35" = 1 Columns "Q" and "AS" have to UnHide. I have tried various VBA Macros from the web with no success. I am using Excel 2010, 2013 and 2016 on different computers that run this spreadsheet.

Any help would be appreciated.

As it is at beginner level - just with Find method like in VBA inner help - at least show your code attempts …

Originally Posted by Stealth2017

If any Cell in Range "BF9:BF35" = 1 Columns "Q" and "AS" have to UnHide.

try

Please Login or Register  to view this content.

Hi Marc L, This is what I currently have: The following code works in Un-Hiding Columns "Q" & "AS" if any cell in the range BF9:BF35 = 1.

Please Login or Register  to view this content.

What I am trying to work out is how to modify this code to include the following:

IF AG9:AG35=1 Un-Hide Columns "R" & "AT", IF AH9:AH35=1 Un-Hide Columns "S" & "AU" and IF AI9:AI35=1 Un-Hide Columns "T" & "AV"

Bill.