Posts by IHeartExcel

    I am working on a macro that puts formulas in cell-based on the address. Need help figuring out the issue. below is the line I am struggling with. I have moved the quotes and when I do I get a "sub or function not defined" highlighting the word sum. any help is greatly appreciated.

    Cells(7, iKVI).Value = “=“ & Cells(7, iSum).Address(RowAbsolute:=False, ColumnAbsolute:=False)” & “/SUM(“ & Range(Cells(7, iSales), Cells(LastRow, iSales)).Address & “)”