View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davemon davemon is offline
external usenet poster
 
Posts: 7
Default macro restricted to one column

I have the following macro, but I would like to run only when a "w" is
entered in any cell in column A.
Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Value = "w" Then
Range("I" & ActiveCell.Row).Select
End If
End Sub

Thanks in advance for the help!!!