In copying a particular range of cells from one workbook to another, I found that cells with formula text containing a local absolute cell reference, e.g. =$F$3, do not get adjusted according to the location of the desti…...CopyCellsWithOptions() { // Load the source workbook Workbook...sourceWorkbook.Worksheets[0]; // Load the destination workbook Workbook...