Thread: magic cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Omega Omega is offline
external usenet poster
 
Posts: 15
Default magic cell

Nigel,

It works! Thank you very much for your help!

Omega

"Nigel" wrote:

To monitor a column use something like

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 8 Then DisplayFarCell_AA
End Sub



--

Regards,
Nigel