Hi All,

I have a sheet with a code. I would like to make multiple copies of
this sheet, Is there a way to make the code change references
automatically?

for example:
I have a sheet with table in the range(A1:P1) and I have vba code
which performs mathematical calculations and gives me the result in
another table in the same sheet. All tables have names and vba code
uses range names to identify position and value.

When I make a copy of this sheet, the code still refers to the range
in sheet1

Is there a way to change all references to local sheet.

I hope my explanation is clear

Can anyone help me?

Thanks
vishnu