| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VB CODE
Please can anybody help me check this code why is not working. If set of date
below change then Latest Update date on column "10" should automatically change. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("14:578")) Is Nothing Then Exit Sub If Target.Cells.Count 10 Then Exit Sub Application.EnableEvents = False Cells(10, Target.Column).Value = Date Application.EnableEvents = True End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Threaded Mode
