i apoligize if this is easy but i am stumped. i'll try not to bore anyone with too many details. on one page of a worksheet, i am working in a grid that is 25 cells square. within the grid are numerous cells linked to page 2 of the worksheet. (all are simple value transfers =worksheet2!a1 etc..) my problem is i need to copy this grid 20-30 times and paste vertically below the original grid. whenever i do and whatever i try the cell references are changed by the "smart" program assuming i want to move the references because the pasted grid has moved. is there a way to turn off this smart feature so i can paste and keep the original cell references? also, is there a fast way to change 1 part of the formula for all cells in this pasted area? each grid i paste will be referencing a different sheet in the workbook and i dread changing all these manually. thanks for your help.