• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

convert RC1 formula to range

D

delta

Member
how RC1 formula convert to range formula

Range("H11").FormulaR1C1 = "=SUM(R[-9]C:R[-1]C)"
Range("H12").FormulaR1C1 = "=R[-1]C*0.04"
Range("H13").FormulaR1C1 = "=R[-2]C*0.01"
Range("H14").FormulaR1C1 = "=SUM(R[-3]C:R[-1]C)"
 
You must log in or register to reply here.
Back
Top