See Bob Phillips' site for this.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP

On Mon, 7 Nov 2005 17:20:14 -0600, mikeburg
wrote:


Is there a formula that obtains the workbook name that I can put in cell
A1?

Also,

Is there a formula that obtains the worksheet name that I can put in
cell A2?

Thanks so very much. mikeburg