Kim,

If ActiveCell.Column = 1 Then
'your code here
End If

If you want it to do the macro each time the user selects a cell in a
certain column use a worksheet SelectionChange event. Enter this in the
code module for the worksheet (by right-clicking the worksheet tab and
choosing "View Code"):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 1 Then
'your code here
End If
End Sub

hth,

Doug

"KimR.Hammel" wrote in message
...
How can I get Excel to check that the Active Cell is in a particular
column
before executing a macro?