I am trying to use a formula with a variable with no success. Could someone point out the syntax for me?
Sub SplitOverheads() Dim LR As Long Dim i As Long Dim ws As Worksheet Set ws = WSOverhead LR = ws.Cells(ws.Rows.Count, 3).End(xlUp).Row + 1 For i = 2 To 20 ws.Cells(LR, 2).Value = ws.Range("J" & i).Value ws.Cells(LR, 3).Value = WorksheetFunction.Sum(Range("K" & i & "/L2")) LR = LR + 1 Next i End Sub
Bookmarks