Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Simple Excel Visual Basic question.

[Subject Prev][Subject Next][Thread Prev][Thread Next]
This example may help, good luck
Sub RANGE()
    ActiveCell.FormulaR1C1 = "=SUM(RC[1]:RC[5])"
    Range("A2").Select
    ActiveCell.FormulaR1C1 = "4"
    Range("A3").Select
    ActiveCell.FormulaR1C1 = "5"
    Range("A4").Select
    ActiveCell.FormulaR1C1 = "6"
    Range("A5").Select
    ActiveCell.FormulaR1C1 = "7"
    Range("A6").Select
    ActiveCell.FormulaR1C1 = "8"
    Range("A7").Select
    ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
    Range("A8").Select
End Sub


How low will we go? Check out Yahoo! Messenger?s low PC-to-Phone call rates.