Copies the formula and (optional) format of the top left-most cell across a range, respecting absolute and relative cell references. This is useful for applying functions that cannot normally be applied to arrays.