Thank you! Sometimes the simpe work arounds are the ones that are thought of
last! That works just fine.
"Bernard Liengme" wrote:
A simple workaround
Put that formula in some out of the way cell (IV1) of Sheet3
In Sheet1 B3 enter =Sheet3!IV1
Remember the CELL function need the file to have saved at least once
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Vince" wrote in message
The following formula works great if you want the cell name to be the
Is there a way to reference a different sheet? For example is there a way
for Sheet 1 Cell B3 to show the name of Sheet 3?
Thanks for you help