Can't you use the sheet codename instead ?
HTH
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Pete
Envoyé : vendredi 10 décembre 2010 20:49
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Tab name chan
This might be a silly question, bit here goes anyways:
Have macro's to repopulate formulas in a given worksheet should it
become necessary. If the tab name changes, the macro which calls for
a certain sheet()select will not find the sheet referenced in the
macro and the macro will not do its job.
