A1 Style References : Cell Reference « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Cell Reference

A1 Style References

 
Sub m()
    Range("D5").Value = "=SUM(D1:D4)"
    Range("D5").Formula = "=SUM(D1:D4)"
End Sub








Related examples in the same category

1.Write a formula in the first 10 columns of row 21 in a worksheet that calculates the standard deviation of the values in rows 2 through 20
2.The Cells property is best suited for use with loops because it accepts numerical parameters representing the row and column indices in a worksheet
3.Entering A1 Versus R1C1 in VBA
4.R1C1 Style
5.R1C1 Style References
6.Use loop to select cells