-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
r.formular1c1
-
[VBA] Changing the range in the code FROM the spreadsheet
Hi Folks. The code I am loading here is about to make calculation in the range ("B4:B18") "BUT" now I need to test the code in different ranges, example B4:B10, and after maybe B4:B22 and keep testing different ranges, so the "FAVOR, PLEASE" I need is type on ("I1") the start, and ("J1") the...- montecarlo2012
- Thread
- =truncindexlinestr4c code r.formular1c1 r18c vba & excel 2010
- Replies: 4
- Forum: Excel Questions
-
VBA A code within a loop
Hi. I have a dynamic array at B3:G2650 and in A3:A20 the numbers from 1 to 17. The double-code uploaded here return the coefficient trend line results at J3:Q10 respectively in this frame and the other just highlight the first row of the array on the report. Until here everything is fine. The...- montecarlo2012
- Thread
- =truncindexlinestr3c cells4 r.formular1c1 r20c vba & excel 2010
- Replies: 10
- Forum: Excel Questions
-
D
Execute different formulas based on conditions
I have the below code in Sheet1; Cells(lastRow + 10, "R").FormulaR1C1 = "=R[-4]C+R[-4]C[-3]" How can I adjust this such that; - If cell F1 in the 'Man' worksheet = 1 then Cells(lastRow + 10, "R").FormulaR1C1 = "=R[-4]C+R[-4]C[-3]" - If cell F1 in the 'Man' worksheet <> 1 then...- deduwa
- Thread
- cellslastrow man r.formular1c1 r[-4]c+r[-4]c[-3 worksheet
- Replies: 5
- Forum: Excel Questions
