Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I guess I have two different commands that are interfereing with each other. I have no clue if they can be combined or how to do that. Any help would be greatly appreciated. I've listed the code below
Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:D")) Is Nothing Then With Target If .Column = 1 Then Cells(Rows.Count, .Column).End(xlUp).Offset(0, 1).Select If .Column = 2 Then Cells(Rows.Count, .Column).End(xlUp).Offset(0, 1).Select If .Column = 3 Then Cells(Rows.Count, .Column).End(xlUp).Offset(1, -2).Select End With End If If Target.Cells.Count 1 Then Exit Sub If Not Intersect(Target, Range("A1:A10000,B1:B10000,C1:C10000")) Is Nothing Then 'set your range here ActiveSheet.Unprotect Password:="" Target.Locked = True ActiveSheet.Protect Password:="" End If End Sub Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'when entering data in a cell in Col A On Error GoTo enditall Application.EnableEvents = False If Target.Cells.Column = 1 Then N = Target.Row If Me.Range("A" & N).Value < "" Then Me.Range("G" & N).Value = Now End If End If enditall: Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ambiguous name detected - help how fix? | Excel Programming | |||
Excel 2007 ambiguous name detected:Worksheet_Change | Excel Programming | |||
Ambiguous Name detected? | Excel Programming | |||
ambiguous name detected | Excel Programming | |||
Ambiguous Name Detected:~ | Excel Programming |