Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
Can I do it withOUT VBA? Maybe it's somewhere in CELL() ?
I want the user to see:
Refer to worksheet Sheet3 for assumptions.
So I want something like
="Refer to worksheet " & sheet(sheet3!a1) & " for assumptions."
Duh, I know it's sheet3 now; but I want it to dynamicly react to sheet name renames.
I want the user to see:
Refer to worksheet Sheet3 for assumptions.
So I want something like
="Refer to worksheet " & sheet(sheet3!a1) & " for assumptions."
Duh, I know it's sheet3 now; but I want it to dynamicly react to sheet name renames.