Hey Guys,

Can somebody help with some explainations on a bit of code.

Dim DataEnd As Long
- what does As long mean

.FormulaR1C1 = "=SUM(R6C5:R[-2]C5)" - what does this part of the formula mean R[-2]
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})"
- can some explain what this mean, i understand the basics of it but not the overall idea of it.

Thanks in advance for any help.
Gav.