Range.Left (Excel)

Returns a Variant value that represents the distance, in points, from the left edge of column A to the left edge of the range.

If the range is discontinuous, the first area is used. If the range is more than one column wide, the leftmost column in the range is used.

Dim lngLeft As Long
lngLeft = ActiveCell.Left