Excel VBA: Evaluate() or square brackets shorthand.

I recommend this trick to shorten the code for entering/copying/calculating data in spreadsheet ranges:
http://www.ozgrid.com/forum/showthread.php?t=52372&page=2

Example:

Sub Test()
    [A1].Offset(0, 1) = [=SUM(Table1[A])]
End Sub