public override void Do() { // Get a backup of target range that will be overwritten backupedGrid = Worksheet.GetPartialGrid(TargetRange, PartialGridCopyFlag.CellData, ExPartialGridCopyFlag.None); try { Worksheet.AutoFillSerial(SourceRange, TargetRange); Worksheet.SelectionRange = RangePosition.Union(SourceRange, TargetRange); } catch (Exception ex) { Worksheet.NotifyExceptionHappen(ex); } }