When I record a macro that includes changing a worksheet it records the sheet by its TAB name.
However if I subsequently change the TAB name the macro does not find the sheet.
Is there a way to record the code so that it registers its "root"sheet number.
tia
kd
However if I subsequently change the TAB name the macro does not find the sheet.
Is there a way to record the code so that it registers its "root"sheet number.
tia
kd