Visual Basic Problem

[murphy0207]

Hi And Thanks For Reading....

My Problem is This, i Have a Formula entered in VB, But i Need It To Work on All Lines of The Workbook.

ATM i Can Only Get it To Work on The First Line..

It Difficult to Explain, So You Can Download Thre Workbook Here

Its Basically A Sheet That Adds To a Specified Total, i Just Cannot Make it Work on Anything But The 1st Row

Thanks

 

[Andrew Poulsom]

Try:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Intersect(Target, Range("J7:J40")) Is Nothing Then Exit Sub
    With Range("N" & Target.Row)
        .Value = .Value + Target
    End With
End Sub

If I were you I would avoid merging cells, as they cause more problems than they solve, particularly with VBA code. Adjust your column widths and row heights to get the look that you want.

 

[murphy0207]

Thank You Andrew, That Works Perfectly..