Macro that looks at cell contents

[andrewb90]

Hi all,

I want to be able to have the user hit a macro button and it will unhide columns C:K but only if there is data in somewhere between rows 10:20.
Is this possible to do?

Thanks,

Andrew

 

[WinteE]

Add a row (A) at the top of the sheet where you calculate a one in the column where there is data in that particular column.
Use the code below to hide/unhide columns

For Each c in Range("A1:Z1")
  If c.Value = 1 Then
    c.EntireColumn.Hidden = True
  Else
    c.EntireColumn.Hidden = False
  End If
Next c

 

[andrewb90]

Add a row (A) at the top of the sheet where you calculate a one in the column where there is data in that particular column.
Use the code below to hide/unhide columns

What exactly do you mean?

 

[WinteE]

When there is data in range A10:A20, then calculate a value 1 for A1.

The macro looks at all cells in the range A1:Z1 and will hide column A as cell value of A1 equals 1.