====== With...End With ======
This saves you from typing what comes after "With" every time you need a property or method.
<code vb>
With Worksheets("Sheet 1")
    .Range("A10").Value = .Range("C2").Value
End With

' the above would be the same as:
' Worksheets("Sheet 1").Range("A10").Value = Worksheets("Sheet 1").Range("C2").Value
</code>