Sum within a cell

  • Hi 2 u all,

    Need help in how to write the next code line in VBA (what is suppose to be in the question marks of course):

    lrow = 24

    for i = 1 to 3

    cells(lrow +1, i) = "sum(????????????????)"

    next i

    TIA

    Nati

  • How are we supposed to know what you are trying to Sum?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Since you didn't actually put an explanation in the file I can only guess that you mean:


    Code
    1. cells(lrow + 1, i).Formular1c1 = "=SUM(R2C:R[-1]C)"

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why