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…...3:28pm 1 In copying a particular range of cells from one workbook to...location of the destination range in the new workbook, while Excel...