I have a range of data which iŽd like to copy to an adjacent area in the same worksheet, within that text are many references in formula to data on another worksheet, is it possibly to change in a single operation all the references in the newly pasted range to another worksheet?