Evaluate Index

[billandrew]

Could someone explain or direct to - How does Index work with Evaluate in this code.

Thank You

Dim Lastrow As Integer


With ActiveSheet
Lastrow = .Cells(Rows.Count, "C").End(xlUp).Row
.Range("C2:F" & Lastrow).Value = .Evaluate("INDEX(proper(C2:F" & Lastrow & "),)")

End With
End Sub

 

[sheetspread]

It's one way of converting all the cells in the range to proper case.