If Column is Table.Columnname Then

[Schwimms]

Hi All,

I can't figure the code out to determine for within a sheet the column selected I am on relates to a specific column of a defined table. This is the code I can't get to work:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = Range("Table_MWTTDB[Month Due]") Then
MsgBox "test"
End If
End Sub

Any ideas what I need to do? Does this make sense?

 

[Schwimms]

I know this is easy I just can't figure it out.. any help please.

 

[Scott R]

If Target.Column = Range("Table_MWTTDB[Month Due]").Column Then

Does that do it?