Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 1sheepdog
  • Content: Threads
  • Order by date
  1. 1sheepdog

    Range("cell").Select increments by 1 after each loop?

    Hi, I am trying to go row by row incrementally for each loan in Excel. Here's what I have so far: For i = 1 To 100 Range("X1").Select ActiveCell.FormulaR1C1 = "=+R[1]C[-10]" Range("X2").Select ActiveCell.FormulaR1C1 = "=+R[2]C[-9]" Next i End Sub How can I incrementally...
  2. 1sheepdog

    Row increments change by 1 after each For...Loop

    Hi, I have a list of loans that I am running cash flows on and trying to go row by row for each loan in Excel. Here's what I have so far: For i = 1 To 100 Range("X1").Select ActiveCell.FormulaR1C1 = "=+R[1]C[-10]" Range("X2").Select ActiveCell.FormulaR1C1 = "=+R[2]C[-9]"...

Part and Inventory Search

Back
Top