View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Norman Jones
 
Posts: n/a
Default Calling procedure when leaving cell

Hi Jeff,

Try:

'=============
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range

If Target.Count 1 Then Exit Sub

Set rng = Me.Columns("K")

If Not Intersect(Target, rng) Is Nothing Then
'Your processing code
End If

End Sub
'<<=============


---
Regards,
Norman



"jeffP" wrote in message
...
Hi all,
I have a datasheet that I've written some code to find the first empty
row.
I will then enter data across that row to Column M. I will enter some
data
in Column K that I want to check by running some IF statements when I
leave
the current cell in Column K. What I don't know how to do is how to call
that
routine when I leave the current cell in Column K.
Is it possible?
Any help or suggestions are always appreciated.