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
    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login