Hi:

Created a worksheet and named many cells for formula purposes, but now I
want to duplicate the worksheet for other jobs. When I create the new
worksheet, the formulas retain the range names and refer back to the
originating worksheet not the current one. What's the easiest way to change
all the formula's to refer to the urrent worksheet. Deleting the name screws
up the formulas.

Thanks...