Is there any way I can have, say cell A1 equal the sheet name?
And vise-versa, the sheet name equals cell A1 (not at the same time.
I tried a bit of VBA, but I can only get it to work once (i.e when sheet1 is no longer called sheet1 I run into problems).
Many thanks in advance
And vise-versa, the sheet name equals cell A1 (not at the same time.
I tried a bit of VBA, but I can only get it to work once (i.e when sheet1 is no longer called sheet1 I run into problems).
Many thanks in advance