Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Posted by jack in the Uk on January 30, 2002 10:44 AM

Help, how can i select target as D2:D65536

so if any cell in D changes it run the script??

Any ideas guy

Thangs as awlays in advance, just one triger cell is not what i need..

Posted by Barrie Davidson on January 30, 2002 10:47 AM

Jack, try this

If Target.Column = 4 Then
'do this
End If

But put this in
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Regards,
BarrieBarrie Davidson

Posted by Jack in the UK on January 30, 2002 11:08 AM

Barry someones cleaver, thank you PERFECT [NT]

Posted by jack in the UK on January 30, 2002 11:13 AM

Barry well done perfect thank you [NT]