Hi there
The Worksheet_Change event doesn;t get fired again to capture the exact row infomation.
The following is the macro i have
This works the first time when i change a cell value from No(which is default) to Yes on a certain cell in the current row. But when i change the same Yes to No and then Yes again and step through the code in debug mode, after previousTargetAddress = Target.Address line it justs straight to Else statement and then end ifPrivate Sub Worksheet_Change(ByVal Target As Range) Application.CutCopyMode = False With Me.Cells .Rows.RowHeight = 15 End With strCurrentRow = Target.Row If Not (previousTargetAddress = Target.Address) Then previousTargetAddress = Target.Address strMaxRange = MaxRangeFinder() strMinRange = "A" StaticNow = Now() StaticTime = Time() Call ModifiedDate(Target) Call BuildDatesUpdater(Target) Call EmailApp(Target) Call CleanUpVariables Else End If
Please advice
Bookmarks