View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] twlove@ontuet.com is offline
external usenet poster
 
Posts: 8
Default Updating cell value by case

I want the value in cell H18 to appear or not appear based on the
value selected and displayed in cell N14. For example, when cell N14
= "Diamond" I want the value in cell H18 to be hidden. Here's my code
but the statement for case "Diamond" won't execute:

Private Sub Worksheet()

Dim Pattern As String

Pattern = Range("N14")

Application.ScreenUpdating = False
Application.ActiveSheet.Range("H18").Select
Application.ScreenUpdating = True

Select Case (Pattern)

'Application.ActiveSheet.Range("H18").Select

Case "Diamond"

Cell.Value = ""

End Select


End Sub