Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
When calling a different file, can I make the tab equal to a cell? | Excel Discussion (Misc queries) | |||
prevent a user leaving a blank cell in excel2003 | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |