I'm sorry in advance because other people have asked similar questions and I've been through them and tried to apply the help given to my situation without success.
I am putting together a mini-database of information and I have a sheet that I want to update automatically every time a change is made, therefore I've set up a few lines telling the sheet what I want it to do as a Worksheet_Change sub (you'll see below):
Private Sub Worksheet_Change(ByVal Target As Range) Call EnableEvents Dim i As Integer For i = 15 To 39 If Sheets("Email Check").Range("C12").Value = "" Then ElseIf Sheets("Email Check").Range("D" & i).Value = "" Then Else Sheets("Email Check").Range("F" & i).Value = Sheets("Email Check Workings").Range("F" & i).Value With Sheets("Email Check").Range("C" & i) .Value = Sheets("Email Check Workings").Range("C" & i).Value .HorizontalAlignment = xlRight End With Sheets("Email Check").Range("H9").Value = i End If Next i End Sub
I don't think I've disabled the events, but as you can see the first thing I'm doing is enabling the events - just as a precaution.
There is data in cell C12 and D15 so the Else part of the if procedure should run. The Email Check Workings sheet is "veryhidden" but the cell F15 on that sheet fills automatically dependent on what is cells C12 and D15 of the Email Check sheet.
I've even put a check in there telling it to put the value of i into cell H9 - just to see if the whole procedure is running - and that is not happenning.
I've been through step by step several times and I just can't see it.
If anyone can help I would be most grateful.