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…...handle such a method call and accept CopyOptions as a parameter...reaches the last line. If I change things to start with a blank...