Hey Guys,
Can somebody help with some explainations on a bit of code.
- what does As long meanDim DataEnd As Long
.FormulaR1C1 = "=SUM(R6C5:R[-2]C5)" - what does this part of the formula mean R[-2]
- can some explain what this mean, i understand the basics of it but not the overall idea of it.TotalsRow = Range("K" & Rows.Count).End(xlUp).Row Range("F6:F" & DataEnd).FormulaR1C1 = "=LOOKUP(R" & TotalsRow & "C11,{1,5000001,10000001},{0.0009,0.0007,0.0005})"
Thanks in advance for any help.
Gav.
Bookmarks