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.
|