Macro to hide column based on value on another sheet

C

CH

I need help with a Macro to hide a column on one sheet with a (yes/no)
value from another sheet.

(So if cell D26 value = Yes then Hide Column H on Sheet named BOY)

Here is the code I am trying to use that creates an error......

If UCase(Range("D26").Value) = UCase("YES") _
Then
Sheets("BOY").EntireColumn("H").Hidden = False
ElseIf UCase(Range("D26").Value) = UCase("NO") _
Then
Sheets("BOY").EntireColumn("H").Hidden = True
End If
 
G

Guest

Try this:


If UCase(Range("D26").Value) = UCase("YES") _
Then
Sheets("BOY").Range("H:H").EntireColumn.Hidden = False
ElseIf UCase(Range("D26").Value) = UCase("NO") _
Then
Sheets("BOY").Range("H:H").EntireColumn.Hidden = True
End If


Michael Arch.

Please rate this posting if helpful
 
C

CH

Works Perfect Thanks!



Try this:

If UCase(Range("D26").Value) = UCase("YES") _
Then
Sheets("BOY").Range("H:H").EntireColumn.Hidden = False
ElseIf UCase(Range("D26").Value) = UCase("NO") _
Then
Sheets("BOY").Range("H:H").EntireColumn.Hidden = True
End If

Michael Arch.

Please rate this posting if helpful








- Show quoted text -
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move row last on change of value 2
Shapes in 2010 1
Hide column based on data validation 0
macro 2
hide multiple worksheets based on a formula value in one cell 1
Run macro on all files in a specific folder 3
VB - With protected sheet 3
adding data column without changing sheets 2

Top