T
Tom-S
Dave, for information, I've come up with a workaround for this problem.
The names that originally referred to say cells A1:C1, now refer to cells
A3:C3. (The 'Refers to' box contains the default type ref, and doesn't use
INDIRECT.)
A3:C3 contain formulas =INDIRECT("A1"), =INDIRECT("B1"), =INDIRECT("C1")
Cells A3:C3 are also locked and formatted ;;; so content only shows in
formula bar. When the sheet is protected, cells A3:C3 cannot be cut & pasted.
Meantime, cells A1:C1 accept the user input values of the names Max_Day_1 to
3.
Call-ups to the names can retain the original format =INDIRECT("Max_Day_" &
Sheet1!$D$4), where cell D4 on Sheet1 contains a user input of either 1, 2 or
3.
All of this means that if the user decides to cut & paste any of A1:C1, the
names stay referenced to A3:C3, and the call-ups still work, which is what I
was trying to achieve.
Thanks for considering the problem along the way.
Regards,
Tom
The names that originally referred to say cells A1:C1, now refer to cells
A3:C3. (The 'Refers to' box contains the default type ref, and doesn't use
INDIRECT.)
A3:C3 contain formulas =INDIRECT("A1"), =INDIRECT("B1"), =INDIRECT("C1")
Cells A3:C3 are also locked and formatted ;;; so content only shows in
formula bar. When the sheet is protected, cells A3:C3 cannot be cut & pasted.
Meantime, cells A1:C1 accept the user input values of the names Max_Day_1 to
3.
Call-ups to the names can retain the original format =INDIRECT("Max_Day_" &
Sheet1!$D$4), where cell D4 on Sheet1 contains a user input of either 1, 2 or
3.
All of this means that if the user decides to cut & paste any of A1:C1, the
names stay referenced to A3:C3, and the call-ups still work, which is what I
was trying to achieve.
Thanks for considering the problem along the way.
Regards,
Tom