Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, can this two macro codes work in the same sheet? Both codes are working
separately, but not together. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "B5" Then _ Range("C1").Value = IIf(IsEmpty(Target), "", "" & UCase(Format(Date, "dddd dd.mm.yyyy"))) 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 And Target.Cells.Row = 5 Then N = Target.Row If Me.Range("A" & N).Value < "" Then With Me.Range("B" & N) If .Value = "" Then ..Value = Now End If End With End If End If enditall: Application.EnableEvents = True End Sub Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Consecutive date range on consecutive worksheets | Excel Worksheet Functions | |||
Transposing data from consecutive rows into non-consecutive rows | Excel Discussion (Misc queries) | |||
Recording find Maros | New Users to Excel | |||
consecutive | Excel Worksheet Functions | |||
Consecutive Cells | Excel Worksheet Functions |