Call Macro after cell changes from a dropdown list

[Carin]

I have a dropdown in C5 that has 12 choices. After someone selects a new item from the list (C5 changed), I would like a macro to run. I right clicked on the sheet ("Report") and input the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$c$5" Then
Call nacleanup
End If
End Sub

My nacleanup code is is Module 1 and is as follows:

Sub nacleanup()
'
' nacleanup Macro

Application.ScreenUpdating = False

Sheets("Creation").Visible = True
Sheets("Creation").Select

Rows("17:218").Select
    Range("d17").Activate
    Selection.EntireRow.Hidden = False
    Range("d17").Select
  
Range("Z17:A218").SpecialCells(xlFormulas, xlErrors).EntireRow.Hidden = True
Sheets("Creation").Visible = False
Sheets("Report").Select
Application.ScreenUpdating = True

'
End Sub

Absolutely nothing happens...please help.

 

[Yongle]

Amend

If Target.Address = "$[COLOR=#ff0000]C[/COLOR]$5" Then

 

[Carin]

OMG! Duh! Thank you! Works like a charm!

 

[Yongle]

We have all been there