On 2002-05-12 18:32, Corni wrote:
What about:
=cell("filename")
On 2002-05-12 19:40, Yogi Anand wrote:
On 2002-05-12 18:32, Corni wrote:
What about:
=cell("filename")
Yes Corni:
=cell("filename") will provide the full filename, including the complete path.
On 2002-05-12 21:20, Yogi Anand wrote:
Hi Chris:
I have not figured out what additional benefit is there in including the second argument ... by the way with or without the second argument viz
=cell("filename")
and
=cell("filename",a1)
both give the same result including the sheet name
nd on 2002-05-12 21:22 ]</font>
trust me, I wasted many an hour at work before I realised this !!)
Anchoring it with A1 specifies the actual sheet the formula is placed on and does not defer to whatever the last-used cell is.