title: CopyOrigin on Insert in Excel VBA
body: <p>Can anyone tell me what the CopyOrigin parameter of Insert is used for?
  And what values it will accept?</p>
  
  <p>I have included the vba help (which wasn't really that helpful):</p>
  
  <blockquote>
    <p>Inserts a cell or a range of cells
    into the worksheet or macro sheet and
    shifts other cells away to make space.</p>
    
    <p>expression.Insert(Shift, CopyOrigin)
    expression    Required. An expression
    that returns a Range object.</p>
    
    <p>Shift   Optional Variant. Specifies
    which way to shift the cells. Can be
    one of the following
    XlInsertShiftDirection constants:
    xlShiftToRight or xlShiftDown. If this
    argument is omitted, Microsoft Excel
    decides based on the shape of the
    range.</p>
    
    <p>CopyOrigin   Optional Variant. The
    copy origin.</p>
  </blockquote>